Re: [sqlite] Running SQLite in memory-only mode

2005-09-26 Thread John Stanton
you still think your suggestion would still work? If not, would SQLite support the memory-only lock-free mode? MR -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 3:00 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Running SQLite in m

Re: [sqlite] Running SQLite in memory-only mode

2005-09-26 Thread Dennis Cote
Radomyselskiy, Mikhail (IT) wrote: We need an engine that runs completely in memory without disk use and that doesn't have to be thread-safe Mikhail, You should be able to use an SQLite memory database. Use the sqlite command shell by starting sqlite3 without a database filename argumen

RE: [sqlite] Running SQLite in memory-only mode

2005-09-26 Thread Radomyselskiy, Mikhail \(IT\)
lock-free mode? MR -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: Monday, September 26, 2005 3:00 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Running SQLite in memory-only mode You might do better not to use any database manager and to place your rules in a

Re: [sqlite] Running SQLite in memory-only mode

2005-09-26 Thread John Stanton
You might do better not to use any database manager and to place your rules in a flat file which you memory map into your program, then use s REGEX regular expression search (or simpler string search) to pop out a list of pointers to the rules. That would be blindingly fast and memory resident