SQLite Forum

Optimize sqllite database
I downloaded your database.  I can't run the software included with it, but I opened the included database in the SQLite command line shell.

The database passes the integrity-check.  The longest table has 1757390 rows.  It displays without problems in the SQLite command line shell.  The last row in the table has <code>id_jim = '1757390'</code> and the other columns are blank, suggesting something went wrong with the input procedure.

There's nothing wrong with the data.  if the program you're using is doing something strange, the problem is with the program.  I suspect it wasn't designed to handle a table with 1757390 rows in.