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, y

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 sql

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 possibl

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 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 t

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 tab

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