Problem with SQLlite
#1

I have a weird problem with my db. Let's start saying that this db is a supermassive db (over 100.000 records) with an index on a single column. Everything works fine at the beginning, every query gets processed in 1 or 2 ms. But after many server restarts (10-15) performance gets worse (like 100-200 ms for a single query). I really can't find the issue, the db is opened only for being readed and it's opened/closed OnGameModeInit/Exit. And i also noticed that if i replace the db with a new one (same db but never used by my samp server) performance go back to normal. Someone knows how to fix it?
Reply


Messages In This Thread
Problem with SQLlite - by Loppa - 26.04.2011, 02:50
Re: Problem with SQLlite - by Blacklite - 26.04.2011, 02:57
Re: Problem with SQLlite - by Joe Staff - 26.04.2011, 03:44

Forum Jump:


Users browsing this thread: 1 Guest(s)