Mailing Lists: Apple Mailing Lists
Image of Mac OS face in stamp
 
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: SQLite optimization


On Aug 29, 2006, at 9:02 AM, Ruslan Zasukhin wrote:

On 8/29/06 3:50 PM, "Aaron Burghardt" <email@hidden> 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.

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.

Regards,

Aaron

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Darwin-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/darwin-dev/email@hidden

This email sent to email@hidden
References: 
 >Re: SQLite optimization (From: Ruslan Zasukhin <email@hidden>)



Visit the Apple Store online or at retail locations.
1-800-MY-APPLE

Contact Apple | Terms of Use | Privacy Policy

Copyright © 2007 Apple Inc. All rights reserved.