SQLite Forum

Timeline
Login

2 forum posts by user akreidly

2020-06-02
16:08 Reply: SQLIGHT performance (artifact: 210bba00a0 user: akreidly)

thank you for your post. i would like to ask you is there any adminisration GUI for SQLITE that might help in this matter .

Knowing that SQLITE is implemented on POS machine, we are expecting high load and no oher db engine could be deployed on a POS machine.

12:45 Post: SQLIGHT performance (artifact: 4c7562f11c user: akreidly)
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