Re: SQLite vs. Apple's Cocoa SQLite
Re: SQLite vs. Apple's Cocoa SQLite
- Subject: Re: SQLite vs. Apple's Cocoa SQLite
- From: Bill Bumgarner <email@hidden>
- Date: Mon, 6 Mar 2006 14:59:20 -0800
On Mar 6, 2006, at 2:52 PM, Scott Ellsworth wrote:
It is possible that the new version, combined with some hand
tuning, would be faster. Try an experiment with data
representative of that which you intend to use. With a bit of
tuning, you can probably make dramatic improvements over the sql
apple generates for a specific data layout. At the least, I have
found that I write better sql than most toolkits if my data has a
special layout.
Of course, that same effort can also get the same benefits by
tuning my data to the framework, and then I get whatever cookies
they bolt on with system updates. Apple's Core Data framework has
a lot of useful machinery built in, and letting it do the heavy
lifting may save you from maintenance headaches.
And Core Data is not just about managing a SQLite data store. It
also does full object graph management, including automatic undo/redo
-- something that is notoriously hard to "get right".
As well, Core Data has a built in caching mechanism that often
eliminates the need to go back to the database. It is very efficient
in Tiger and one can expect additional significant optimizations in
the future.
b.bum
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Cocoa-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden