SQLite Lag
#8
I can't believe our code is doing that, we're just a thin wrapper over sqlite3. Could you try opening the affected DB file in the command-line "sqlite3" utility and try to time the queries there?
Code:
sqlite3 file.sqlite
.timer on
select * from Money;
insert into Money (Money, uuid) values (10, "1234");
update Money set money = 20 where uuid = "1234";
select * from Money;
.exit
Reply
Thanks given by:


Messages In This Thread
SQLite Lag - by gegi123 - 10-31-2015, 04:35 AM
RE: SQLite Lag - by sphinxc0re - 10-31-2015, 07:11 AM
RE: SQLite Lag - by xoft - 10-31-2015, 08:22 AM
RE: SQLite Lag - by gegi123 - 10-31-2015, 10:33 PM
RE: SQLite Lag - by xoft - 11-01-2015, 12:11 AM
RE: SQLite Lag - by NiLSPACE - 11-01-2015, 12:27 AM
RE: SQLite Lag - by gegi123 - 11-01-2015, 01:23 AM
RE: SQLite Lag - by xoft - 11-01-2015, 07:42 AM
RE: SQLite Lag - by gegi123 - 11-01-2015, 07:57 AM
RE: SQLite Lag - by xoft - 11-01-2015, 08:08 AM
RE: SQLite Lag - by gegi123 - 11-01-2015, 08:37 AM
RE: SQLite Lag - by NiLSPACE - 11-10-2015, 10:42 PM
RE: SQLite Lag - by Seadragon91 - 11-10-2015, 11:20 PM
RE: SQLite Lag - by xoft - 11-11-2015, 12:55 AM



Users browsing this thread: 6 Guest(s)