Re: [sqlite] Memory databases

2006-05-24 Thread Joe Wilson
--- Unit 5 <[EMAIL PROTECTED]> wrote: > I have a couple of questions on :memory: databases: > > 1) What happens when a table grows in size more than > the available RAM? Does sqlite revert to file based > mechanism to handle it or would it throw an error? If your OS is Windows or UNIX, your

[sqlite] Memory databases

2006-05-24 Thread Unit 5
I have a couple of questions on :memory: databases: 1) What happens when a table grows in size more than the available RAM? Does sqlite revert to file based mechanism to handle it or would it throw an error? 2) From some of the other posters who have done more testing than I, it seems that

[sqlite] :memory: databases

2006-02-14 Thread Mateus Cordeiro Inssa
Hi, Is it possible to use an :memory: database with a preallocated memory area ? The locking mechanism could still use files, no problem. Or no locking (and I provide the locking mechanism). I have an application with a 5GB shared memory (with the SHM_HUGETLB flag - Linux) and I do all de