What are some of the limitations of using memory tables (operations, counts, etc)? Looking at Linux 32bit intel implementation (RH) and want to do some larger tables all in memory. How large you ask ... as large as I can fit in the typical 2gig workspace.
Also does/can SQLite support 64 Bit O/S native so I could easily get past the some of the memory limits. I just started looking at SQLite and it looks awsome, as well as for other projects kicking around I found some native Delph/C++Builder components as well. Thanks for the newbie help :-) Sandy