On Wed, Dec 16, 2009 at 9:30 AM, Raghavendra Thodime <rthod...@sipera.com>wrote:
> I did try using batch of transactions with synchronous=OFF PRAGMA set. The > performance improved slightly. But as db file started to grow larger and > larger in size, the performance degraded considerably. Is it expected? Or Is > there a work around for this? > If you did everything according this topic: (19) INSERT is really slow - I can only do few dozen INSERTs per second ( http://www.sqlite.org/faq.html#q19 ) from FAQ, you probably have extra overload with your development language/library. Also be aware that you will probably never get the same speed as the general copying of same amount of data with the file system routines since the db engine have to deal with indexes and other extra job. So the performance high or low might be a subjective estimate. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users