On Jul 30, 2008, at 08:14, Simone Tellini wrote:

Keep a prepared SQLite insert statement and reuse it for all the lines, binding the parameters for each line. Don't load the whole file in memory: it's just a waste of memory and time to allocate it. Instead parse a line at a time.

mmap() might also be an option.

andy

_______________________________________________

Cocoa-dev mailing list (Cocoa-dev@lists.apple.com)

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:
http://lists.apple.com/mailman/options/cocoa-dev/archive%40mail-archive.com

This email sent to [EMAIL PROTECTED]

Reply via email to