Re: [sqlite] In memory data base questions ???

2008-05-01 Thread Alex Katebi
THANKS Igor! On Tue, Apr 29, 2008 at 6:38 PM, Igor Tandetnik [EMAIL PROTECTED] wrote: Alex Katebi [EMAIL PROTECTED] wrote: Just want to make a note that when I say in-memory data base I don't mean the cache memory I mean the :memory: date base. That's how I understood you, yes. Igor

[sqlite] In memory data base questions ???

2008-04-29 Thread Alex Katebi
Hi, I am planning to use only in-memory data base for my application. I have couple of questions? 1) Would SQLite still make Rollback Journal files? If yes can it be turned off with pragma, etc.? 2) If I have a single in-memory connection with multiple statements, should I worry about

Re: [sqlite] In memory data base questions ???

2008-04-29 Thread Igor Tandetnik
Alex Katebi [EMAIL PROTECTED] wrote: I am planning to use only in-memory data base for my application. I have couple of questions? 1) Would SQLite still make Rollback Journal files? No. 2) If I have a single in-memory connection with multiple statements, should I worry about table

Re: [sqlite] In memory data base questions ???

2008-04-29 Thread Alex Katebi
Hi Igor, So are you telling me that if a statement has started a select on a table with a delayed finalize another statement can update the same table? The reason I ask this question is that in my application a user can start a query and take his time before he ends it. Meanwhile the same

Re: [sqlite] In memory data base questions ???

2008-04-29 Thread Alex Katebi
Just want to make a note that when I say in-memory data base I don't mean the cache memory I mean the :memory: date base. On Tue, Apr 29, 2008 at 5:39 PM, Igor Tandetnik [EMAIL PROTECTED] wrote: Alex Katebi [EMAIL PROTECTED] wrote: I am planning to use only in-memory data base for my

Re: [sqlite] In memory data base questions ???

2008-04-29 Thread Igor Tandetnik
Alex Katebi [EMAIL PROTECTED] wrote: So are you telling me that if a statement has started a select on a table with a delayed finalize another statement can update the same table? Yes, as of recent enough SQLite version. I'm kind of skeptical myself, but Dr. Hipp insists this is possible

Re: [sqlite] In memory data base questions ???

2008-04-29 Thread Igor Tandetnik
Alex Katebi [EMAIL PROTECTED] wrote: Just want to make a note that when I say in-memory data base I don't mean the cache memory I mean the :memory: date base. That's how I understood you, yes. Igor Tandetnik ___ sqlite-users mailing list