[Loppa]

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?

[Blacklite]

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

[Joe Staff]

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