[sqlite] Shadow Pager

Has anyone implemented the shadow pager for sqlite??? Any info regarding this will be very helpful.. Thanks Sankarshana M __ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail

[sqlite] SQLite "single writer"

A program that I wrote eventually continues to return SQLITE_BUSY when it tries to insert a new row into a table, even though I'm pretty sure that at each attempted time of insert (at least when it continually returns SQLITE_BUSY), there are no other SQL commands running. I inserted

Re: [sqlite] Efficient select for multiple ids

Ken Cooper wrote: SELECT id, . FROM additionalchunks WHERE id=? OR id=? OR . or SELECT id, . FROM additionalchunks WHERE id in (? ? ? ? ? .) Which of these is the more efficient... The second, assuming you have an index on additionalchunks.id. Without an index, they are about the same. -- D.

Re: [sqlite] Improving Performance of INSERT INTO?

Roger Dant wrote: I didn't realize sqlite3 had transaction support! I must have missed it in the documentation -- off to re-read it. Sqlite2 has transaction support and I don't think it's been removed for sqlite3.

Re: [sqlite] Improving Performance of INSERT INTO?

Will Leshner <[EMAIL PROTECTED]> wrote: >Try doing all the INSERTs in a single transaction. I didn't realize sqlite3 had transaction support! I must have missed it in the documentation -- off to re-read it. Thanks. - Do you Yahoo!?

Re: [sqlite] Improving Performance of INSERT INTO?

On Wed, Sep 15, 2004 at 02:14:58PM -0700, Roger Dant wrote: > > Here's the slow code: > > sqlite3* db; > CString sql; > sqlite3_open("c:\\test.db", ); > sqlite3_exec(db, "PRAGMA SYNCHRONOUS", NULL, NULL, NULL); > sqlite3_exec(db, "CREATE TABLE X (I LONG, J LONG)", NULL, NULL, NULL); > for (int

Re: [sqlite] Improving Performance of INSERT INTO?

Roger Dant wrote: Since INSERT INTO is the only way I know of to populate a table, I'm assuming that I'll have to find a way to optimize these calls. Do you have any tips for optimizing mass INSERTs in Sqlite? Try doing all the INSERTs in a single transaction.

[sqlite] Improving Performance of INSERT INTO?

Hi, I'm working on a program that builds a table with 2 columns and up to 500,000 rows. I'm using INSERT INTO to add each row, and the process takes 2 - 3 hours to finish. Since INSERT INTO is the only way I know of to populate a table, I'm assuming that I'll have to find a way to

RE: [sqlite] Efficient select for multiple ids

The '.'s below should be ellipses. -Original Message- From: Ken Cooper [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 15, 2004 1:56 PM To: [EMAIL PROTECTED] Subject: [sqlite] Efficient select for multiple ids I am implementing a virtualized listview on the result of a query by

[sqlite] Efficient select for multiple ids

I am implementing a virtualized listview on the result of a query by first retrieving all unique ids for each row in the query result, then on demand looking up additional information based on the ids in small chunks, say 20 at a time. I was thinking the best way to approach this second query was

[sqlite] invalid btree cursor read locks honored?

I'm having problems with code that starts a transaction, creates a table, commits, begins a new transaction, creates a temporary table, inserts data into the temporary table, and the inserts into the table the results of a select from the temporary table. The insert statement results in a

Re: [sqlite] like-op

Low, indeed! It amazes me how ordinary citizens are always ready to jump in with inane remarks like that. As it turns out, LIKE is a lot smarter than I thought, e.g. this works: WHERE FLAGS LIKE '% % 1 %' As long as there are at least 3 blanks in each FLAGS value. I suspect that it

[sqlite] Temproary File Size

Hi, I am be porting Sqlite3.0 for an embedded application. I need to initiate my file system with the space required for storing the database file and temporary files. The maximum size of the database file that could be used is 2MB (fixed and checks are done that this size does not exceed).

[sqlite] sqlite on Cygwin ignoring Unix style paths

I have noticed this for sqlite 2.8.15 and 3.0.6 (both compiled under Cygwin): sqlite doesn't recognise Unix style paths for opening databases (but "-init unix_path" works). Cygwin itself supports both paths styles. Symptoms: [EMAIL PROTECTED] pwd /home/tkampe [EMAIL PROTECTED] sqlite3 test.db

Re: [sqlite] like-op

Le mer 15/09/2004 à 00:43, Peter a écrit : > Rod Dav4is wrote: > > > I'm reminded of the guy who wanted to buy a loaf of bread and was told > > how to build a bakery. ;O) > > Don't hesitate to contact customer services to arrange for your 30day no > quibble refund. :-Þ THAT whas low.