Re: [sqlite] Memory databases ...

2008-10-06 Thread Rob Sciuk
Mihai Limbasan wrote: > Yes - use ":memory:" (without the double quotes) as the database name > when opening it. Be aware, though, that all tables and their contents > will disappear once you close the database connection. Actually, this brings up the question of the ability to mmap a file, and

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 syst

[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 there

[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