site_archiver@lists.apple.com Delivered-To: darwin-dev@lists.apple.com On Aug 29, 2006, at 9:02 AM, Ruslan Zasukhin wrote: On 8/29/06 3:50 PM, "Aaron Burghardt" <aburgh@mac.com> wrote: You don't say whether you are querying the database or inserting data. SQLite does not open the db file for each SQL statement, but when inserting data it creates a separate journal file for each transaction, so there is a fair amount of overhead per insert transaction. Actually any dbms with transactions do this. Regards, Aaron _______________________________________________ Do not post admin requests to the list. They will be ignored. Darwin-dev mailing list (Darwin-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/darwin-dev/site_archiver%40lists.appl... DB need to have for each transaction separate *logical* file. It can be inside of some "virtual volume" but this not change main point. The main point is performance and what SQLite is capable of with regards to the OP's needs, is it not? SQLite performance improves substantially when multiple inserts are performed within a single transaction because of the overhead of setting up the transaction. Another db may be necessary to achieve what he needs, but frankly I don't think enough detail is known at this point to make that judgement. This email sent to site_archiver@lists.apple.com