Re: [sqlite] MMAP

Christian Smith wrote: On Wed, 19 Apr 2006, John Stanton wrote: Chris, Thanks for the very pertinent comments on segment linking. I am not sending an Sqlite database. It is the output from my program, principally assembled HTML/PDF/PostScript and similar. I want to avoid buffer shadowing

[sqlite] sqlite3_finalize() thread-safety (was: Re: [sqlite] Direct use of SQLite btree functions / performance)

Am 19.04.2006 um 15:31 schrieb [EMAIL PROTECTED]: Felix Schwarz <[EMAIL PROTECTED]> wrote: Hi, I have just discovered these old message on the SQLite Yahoo! Group: http://groups.yahoo.com/group/sqlite/message/2115 http://groups.yahoo.com/group/sqlite/message/2117 This does sound very

Re: [sqlite] Transactions and sqlite3_last_insert_rowid

Dennis Cote wrote: What happens to the ROWID when the transaction is rolled back? Is it as if the record with that ROWID was deleted? Yes If I understand it correctly, connection C1 can do an INSERT, get ROWID 4, C2 does an INSERT, gets 5, and commits, and then C1 commits, with its 4; if

Re: [sqlite] Transactions and sqlite3_last_insert_rowid

Michael Ekstrand wrote: [EMAIL PROTECTED] wrote: The ROWID is generated after the BEFORE triggers fire and before the row is inserted. OK, I think I'm getting it. The INSERT statement generates the ROWID, fires triggers, then inserts the row. When the transaction is committed, all

Re: [sqlite] MMAP

On Wed, 19 Apr 2006, John Stanton wrote: >Chris, Thanks for the very pertinent comments on segment linking. > >I am not sending an Sqlite database. It is the output from my program, >principally assembled HTML/PDF/PostScript and similar. > >I want to avoid buffer shadowing on the content my

Re: [sqlite] Expr.iTable question

--- [EMAIL PROTECTED] wrote: > Joe Wilson <[EMAIL PROTECTED]> wrote: > > > > What is the recommended way to match a TK_COLUMN Expr from > > a Select's pEList with its corresponding Select.pSrc > > SrcList_item? > > > > Do you forsee any technical problem with recursively descending > > the

Re: [sqlite] Separated transactions - stable consistency

[EMAIL PROTECTED] írta: DurumDara <[EMAIL PROTECTED]> wrote: I want to use SQLite database like the FireBird database: with big isolation level. SQLite transactions are SERIALIZABLE. It is possible to force SQLite transactions to be READ UNCOMMITTED under some special circumstances,

Re: [sqlite] Direct use of SQLite btree functions / performance

--- [EMAIL PROTECTED] wrote: > Joe Wilson <[EMAIL PROTECTED]> wrote: > > > > If you read the blob all in at once, true. > > But doesn't sqlite3BtreeData() allows you to read a partial chunk of > > data from the blob at an arbitrary offset? This could be advantageous > > if you are dealing with

Re: AW: [sqlite] Direct use of SQLite btree functions / performan ce

Chris Werner <[EMAIL PROTECTED]> wrote: > OK, I'll bite: How do we get SQLite ver 4? > > Is there a CVS Tag I am missing? > You misunderstand. There is no SQLite v4. What I was saying is that the requested change (pagable blobs) would require an incompatable file format change, which would

RE: AW: [sqlite] Direct use of SQLite btree functions / performan ce

OK, I'll bite: How do we get SQLite ver 4? Is there a CVS Tag I am missing? Good work by the way! Christian Werner -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 9:33 AM To: sqlite-users@sqlite.org Subject: Re: AW: [sqlite] Direct

Re: AW: [sqlite] Direct use of SQLite btree functions / performance

[EMAIL PROTECTED] wrote: > Maybe I'm missing something here, but there should be an interface to page a > blob into memory. Especially for large blobs, this would make sense to me to > not load them into memory at once. > > If sqlite doesn't provide this already, it would probably make a lot of

AW: Re: [sqlite] Direct use of SQLite btree functions / performance

Maybe I'm missing something here, but there should be an interface to page a blob into memory. Especially for large blobs, this would make sense to me to not load them into memory at once. If sqlite doesn't provide this already, it would probably make a lot of sense to include this

Re: [sqlite] Direct use of SQLite btree functions / performance

Joe Wilson <[EMAIL PROTECTED]> wrote: > > If you read the blob all in at once, true. > But doesn't sqlite3BtreeData() allows you to read a partial chunk of > data from the blob at an arbitrary offset? This could be advantageous > if you are dealing with multi-megabyte blobs and do not

Re: [sqlite] Direct use of SQLite btree functions / performance

--- [EMAIL PROTECTED] wrote: > Felix Schwarz <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I have just discovered these old message on the SQLite Yahoo! Group: > > > > http://groups.yahoo.com/group/sqlite/message/2115 > > http://groups.yahoo.com/group/sqlite/message/2117 > > > > This does sound

Re: [sqlite] Direct use of SQLite btree functions / performance

Felix Schwarz <[EMAIL PROTECTED]> wrote: > Hi, > > I have just discovered these old message on the SQLite Yahoo! Group: > > http://groups.yahoo.com/group/sqlite/message/2115 > http://groups.yahoo.com/group/sqlite/message/2117 > > This does sound very interesting! If I simply want to store

Re: [sqlite] Separated transactions - stable consistency

DurumDara <[EMAIL PROTECTED]> wrote: > > I want to use SQLite database like the FireBird database: with big > isolation level. SQLite transactions are SERIALIZABLE. It is possible to force SQLite transactions to be READ UNCOMMITTED under some special circumstances, but you have to work very

[sqlite] Separated transactions - stable consistency

Hi ! I want to use SQLite database like the FireBird database: with big isolation level. What's that meaning ? I have an application that periodically check some input directory, process the elements in it, and copy them into a global database. It is like a daemon, working in the background.

[sqlite] Direct use of SQLite btree functions / performance

Hi, I have just discovered these old message on the SQLite Yahoo! Group: http://groups.yahoo.com/group/sqlite/message/2115 http://groups.yahoo.com/group/sqlite/message/2117 This does sound very interesting! If I simply want to store binary data that I want to access via an index number again

[sqlite] Re: How to escape % chars?

André Goliath <[EMAIL PROTECTED]> wrote: sorry for that dump question, but how to escape % chars in a column LIKE '%the income was 50%%' statement? I want the second % threated as regular character and the first and last % as wildcards. field LIKE '%the income was 50\%%' ESCAPE '\' Any

[sqlite] Re: How to improve performance of SQL DELETE

Kai Wu <[EMAIL PROTECTED]> wrote: 2. The table schema is simple TABLE MID(id VARCHAR(8),scts VARCHAR(12),daddr VARCHAR(20)) the scenario is it needs first select the "id" by select id from MID where scts= .. AND daddr=... after the id field is retrieved, this entry can be

[sqlite] How to improve performance of SQL DELETE

Hi there, We have an application using sqlite, the situation is it does a lot INSERT and DELETE, after we bundle all INSERTs and DELETEs in transactions, INSERT becomes a lot faster, but DELETE seems still suffers.i have two questions. 1. Is there a way to tell sqlite to do "cheap" delete ? for

[sqlite] How to escape % chars?

Heyo, sorry for that dump question, but how to escape % chars in a column LIKE '%the income was 50%%' statement? I want the second % threated as regular character and the first and last % as wildcards. I can´t seem to figure it out,... Thanks, André