site_archiver@lists.apple.com Delivered-To: darwin-dev@lists.apple.com Thread-index: AcbLa3O3soMVGjdeEdu3SQANkzDgag== Thread-topic: SQLite optimization User-agent: Microsoft-Entourage/11.2.0.050811 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. DB need to have for each transaction separate *logical* file. It can be inside of some "virtual volume" but this not change main point. -- Best regards, Ruslan Zasukhin VP Engineering and New Technology Paradigma Software, Inc Valentina - Joining Worlds of Information http://www.paradigmasoft.com [I feel the need: the need for speed] _______________________________________________ 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... This email sent to site_archiver@lists.apple.com