03.02.2019, 10:45
SA-MP uses SQLite version 3.7.0.1 which was released in 2010-08-04. It is 98 releases behind the latest version. There are many compile-time options that would help speed it up if the library was compiled with.
You need to create index at the column you order by with. If using it correctly (optimized database), it can select a column from 2.5 million rows in 1 millisecond.
You mentioned the file size is 70MB. How many tables, columns per table, rows and indexes does it have? Indexes speedup select queries, increase file size and slow down insert/update/delete queries. The more data, the slower writing to database will be.
If you ever consider to switch to MySQL, do not even hesitate to do it. Importing the data from SQLite should not be difficult.
You need to create index at the column you order by with. If using it correctly (optimized database), it can select a column from 2.5 million rows in 1 millisecond.
You mentioned the file size is 70MB. How many tables, columns per table, rows and indexes does it have? Indexes speedup select queries, increase file size and slow down insert/update/delete queries. The more data, the slower writing to database will be.
If you ever consider to switch to MySQL, do not even hesitate to do it. Importing the data from SQLite should not be difficult.