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 will work on a
network filesystem, but its speed will be limited by the
speed of the network filesystem, and network filesystems
are normally *very slow*.  For best results, you should
locate your database file on a local filesystem.

Do you have multiple machines that need to access the
same database?  If so, then consider building a lightweight
server process wrapper around SQLite and let each of the
clients talk to the server using TCP/IP.  That will normally
be much faster than sharing the database file on a network
filesystem.  Or, consider using a client/server database
engine.


-- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565


--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to