Insert issues on SQLite3

If you are inserting a large number of entries in a SQLite3 table, it is highly recommended that the table doesn't have any indexes (primary keys included), because in indexed tables the time that takes each new insert becomes longer. In contrast, if the table isn't indexed, the insert time is always the same. If you need and indexed table, you could always add indexes after massive insertions.