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, I'm doing BEGIN/END around
>the entire transaction. I've removed indexes and set PRAGMA
>default_synchronous = OFF on the database, but it didn't have much
>effect. Oh, and I'm using a pre-compiled query to do the insert, too. I
>can't use a temporary table, either, because I need to share the data
>between the network and UI threads.
Where is the data coming from? If it's coming through a cable modem from
the office, I'd expect it to be slower than if reading directly from the
office LAN.
Make sure it actually is sqlite that is the bottleneck. Check that you can
actually get the data as fast at home.
Christian
--
"The problem with the French is that they don't have a word for entrepreneur"
George W. Bush
----------------------------------------------------------------------
/"\
\ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
X - AGAINST MS ATTACHMENTS
/ \
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
