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]
