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.
Why do you need SQLite if you want everything in memory? All you gain is an SQL Parser to operate on the data structures instead of just doing it directly yourself.
On the other hand if you use on disk databases you can tell SQLite how much memory to use as a page cache. The default is 2MB.
Roger
