Re: Questions about Core Data and SQLite
Re: Questions about Core Data and SQLite
- Subject: Re: Questions about Core Data and SQLite
- From: Jens Alfke <email@hidden>
- Date: Mon, 14 Jul 2008 21:08:25 -0700
On 14 Jul '08, at 6:05 PM, Steve Steinitz wrote:
I use a little gigabit Thecus Network Drive which is just about as
fast as using the internal disk. Humorously, my database currently
fits in the Thecus' cache so it runs even faster.
The scalability problem isn't the I/O speed, but the fact that the
clients are using filesystem locks for mutual exclusion, and polling
the lock for scheduling. Typically if the file is locked the process
will wait a few seconds, then try again. As the percentage of busy
time of the file increases, the delay to access it gets unacceptably
long.
At that point you really want a database server that can queue
requests and schedule them efficiently and fairly.
—Jens
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________
Cocoa-dev mailing list (email@hidden)
Please do not post admin requests or moderator comments to the list.
Contact the moderators at cocoa-dev-admins(at)lists.apple.com
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden