SQLite Forum

SQLIGHT performance
Login
Dears, 

I have installed and using SQLITE on Android Machine, im facing performance issues especially during an insert statements as the below example: 
 im inserting 10000 records: using BEGIN TRANSACTION the first 2000 inserts are done in sec and the second 2000 take more time and the 2000 take more and the last 2000 might take up to 30 minutes. 
any help is appreciated. 
moreover, is it parctically better to install multiple instances of sqlite if i have this amount of data (i have millions of records) and what im experiening might be caused by this amount of huge data. 

im using index on some columns as they are needed, i tried to remove the index it helps a little but i have to use indexes , knowing that even if i remove the index the performance is not acceptable as its taking time to insert