MySQL Forums
Forum List  »  SQLite

INSERTS: Mysql vs SQlite
Posted by: alexey petrovsky
Date: May 28, 2006 01:48AM

:: If SQLite can do what I want, I think MySQL should be able to also.

No, that's not correct.

SQlite may have some problems when importing large data (I've read about it in SQlite mailing list, it's very friendly and often drh, the inventor and creator of SQlite answer to your questions quick and to the point).

Par example, large genetic databases with million of huge rows may insert slowly as well. But SQLite is very specialized solution and sometimes it's queries are more compliant to the standards and well performed in SQLite (or Postgress). Drawbacks of SQlite are well known and documented.

So, check if you have no indexes when importing large databases (you mentioned it). You may add it later. Turn any sync options off.

Options: ReplyQuote

Written By
July 22, 2005 05:01PM
INSERTS: Mysql vs SQlite
May 28, 2006 01:48AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.