Problem with SQLlite - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Problem with SQLlite (/showthread.php?tid=251200)

---

Problem with SQLlite - Loppa - 26.04.2011

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?

---

Re: Problem with SQLlite - Blacklite - 26.04.2011

Can you post the queries (code) you are using?

---

Re: Problem with SQLlite - Joe Staff - 26.04.2011

Perhaps you're experiencing a memory leak or multiple instances, check to make sure you're not opening the database more than once and that your utilizing db_free_result(...) apropriately

---