RE: [sqlite] OT: bush misquote (was Re: [sqlite] more performance questions)

2004-03-19 Thread Fred Williams
AIL PROTECTED] > Sent: Friday, March 19, 2004 6:22 AM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: [sqlite] OT: bush misquote (was Re: [sqlite] more > performance questions) > > > On Thu, 18 Mar 2004 [EMAIL PROTECTED] wrote: > > >On Mar 18, 2004, at 11:

Re: [sqlite] OT: bush misquote (was Re: [sqlite] more performance questions)

2004-03-19 Thread Christian Smith
On Thu, 18 Mar 2004 [EMAIL PROTECTED] wrote: >On Mar 18, 2004, at 11:28 AM, David Morel wrote: > >> Le jeu 18/03/2004 à 15:42, Christian Smith a écrit : >> | "The problem with the French is that they don't have a word for >> entrepreneur" >> | George W. Bush >> >> did the man realy SAY that? > >N

Re: [sqlite] more performance questions

2004-03-18 Thread Peter
Dave Hayden wrote: On Mar 18, 2004, at 1:30 PM, Corporate wrote: Two words! Thread Synchronization! (above the database API in your code). Works like a charm. I just sat down with a cup of coffee and came to the came conclusion... It's a shame the MailingList settings are the cause of transformin

Re: [sqlite] more performance questions

2004-03-18 Thread Dave Hayden
On Mar 18, 2004, at 1:30 PM, Corporate wrote: Two words! Thread Synchronization! (above the database API in your code). Works like a charm. I just sat down with a cup of coffee and came to the came conclusion--if I keep only one connection to the database and do the mutexing myself, I get bett

Re: [sqlite] more performance questions

2004-03-18 Thread dave
On Mar 18, 2004, at 12:14 PM, D. Richard Hipp wrote: To run a query within a transaction, you also have to compile it within a transaction. To run a query outside of a transaction it should be compiled outside of the transaction. Aha! It's fast again! Now I have to figure out how to deal with a

[sqlite] OT: bush misquote (was Re: [sqlite] more performance questions)

2004-03-18 Thread dave
On Mar 18, 2004, at 11:28 AM, David Morel wrote: Le jeu 18/03/2004 à 15:42, Christian Smith a écrit : | "The problem with the French is that they don't have a word for entrepreneur" | George W. Bush did the man realy SAY that? Nah: http://www.snopes.com/quotes/bush.htm It's a variation on t

Re: [sqlite] more performance questions

2004-03-18 Thread David Morel
Le jeu 18/03/2004 à 15:42, Christian Smith a écrit : | "The problem with the French is that they don't have a word for entrepreneur" | George W. Bush did the man realy SAY that? ROTFL -- [EMAIL PROTECTED] OpenPGP public key: http://www.amakuru.net/dmorel.asc

Re: [sqlite] more performance questions

2004-03-18 Thread Christian Smith
On Wed, 17 Mar 2004, Dave Hayden wrote: >I'm inserting a bunch of data loaded off the network into a table. Here >at the office, SQLite keeps up pretty well; at home on the cable modem, >it's a huge bottleneck. Loading now takes about 10x what it used to >when we were just storing in memory. Yes,

Re: [sqlite] more performance questions

2004-03-18 Thread D. Richard Hipp
[EMAIL PROTECTED] wrote: > I'm trying to insert some 1,000 rows a second, with about 200-300 bytes per > row--it's overview data from an NNTP server. Also, FWIW, this is on OS X and > I've bumped the page size up to 4096 since that's the memory page size (I > think), and the rows were exactly the w

Re: [sqlite] more performance questions

2004-03-17 Thread dave
On Mar 17, 2004, at 5:44 PM, D. Richard Hipp wrote: Dave Hayden wrote: > I'm inserting a bunch of data loaded off the network into a table. Here at > the office, SQLite keeps up pretty well; at home on the cable modem, it's a > huge bottleneck. Is the database file on a network filesystem? If

Re: [sqlite] more performance questions

2004-03-17 Thread D. Richard Hipp
Dave Hayden wrote: > I'm inserting a bunch of data loaded off the network into a table. Here at > the office, SQLite keeps up pretty well; at home on the cable modem, it's a > huge bottleneck. Is the database file on a network filesystem? If so, that is probably the cause of your problem. SQLite

[sqlite] more performance questions

2004-03-17 Thread Dave Hayden
I'm inserting a bunch of data loaded off the network into a table. Here at the office, SQLite keeps up pretty well; at home on the cable modem, it's a huge bottleneck. Loading now takes about 10x what it used to when we were just storing in memory. Yes, I'm doing BEGIN/END around the entire tra