"SQLite is not designed to replace Oracle. It is designed to replace fopen()."

Re:"SQLite is not designed to replace Oracle. It is designed... by lsb on Friday July 29, 2011 @11:20PM (#2824756)

In SQLite, autocommit is on, so if you weren't explicitly setting your transactions, you might have been commit after each update. Also, the standard disk cache is 2MB, so if you think your DB should have more memory than that, up it with default_cache_size.

[ Parent | on HN ]

Re:"SQLite is not designed to replace Oracle. It is designed... by kellishaver on Saturday July 30, 2011 @05:06PM (#2826761)

Ah, I wasn't, so that combined with pilif's comments regarding the file being locked for writes would make a lot of sense as to why things were slowing down.

Thanks for the info.

[ Parent | on HN ]