MobileRead Forums - View Single Post

kovidgoyal · 04-29-2011, 11:34 AM

I would suggest minimizing writes to the db. i.e. keep your lists in memory until the end of the search and only then write to the database, preferably with a single executemany call.You probably need to add another API method to database2 for that.

04-29-2011, 11:34 AM	#208
kovidgoyal creator of calibre Posts: 45,455 Karma: 27757438 Join Date: Oct 2006 Location: Mumbai, India Device: Various	I would suggest minimizing writes to the db. i.e. keep your lists in memory until the end of the search and only then write to the database, preferably with a single executemany call.You probably need to add another API method to database2 for that.