Sourcemod changes on SQL in the last 2month

TheWho · **Author**

Hey,

can anyone tell me what sourcemod changed in the last 2 month that could cause some problems with SQL? Because since the update my querys takes so much time and a lag time of 0.8 seconds.

Ech save of data results in a 0.8 seconds lag, the database has over 25.000 rows but even with a empty database it cause lags. I didnt updated sourcemod since ~2month.

Mitchell · 09-12-2014 , 13:49 Re: Sourcemod changes on SQL in the last 2month

are these threaded queries? The game shouldnt lag if they are.

TheWho · 09-12-2014 , 18:23 Re: Sourcemod changes on SQL in the last 2month

Actually it is threaded :/
"SQL_TQuery"

BAILOPAN · 09-13-2014 , 19:17 Re: Sourcemod changes on SQL in the last 2month

@TheWho are you using MySQL or SQLite as a backend? And how many queries would you estimate get queued up per second?

TheWho · *Last edited by TheWho; 09-13-2014 at 21:15.*

It was SQLite but I rewrote the plugin to MySQL now, that fixed the problem.
Result = Don't save much data in SQLite.
One query only and not every second, there is much space between the queries.

And now I can display it in tables with php so it was a good choice to rewrite it

BAILOPAN · 09-14-2014 , 00:45 Re: Sourcemod changes on SQL in the last 2month

@TheWho: Glad to hear it's better now - but it would still be useful to have an answer to the question. 25,000 rows doesn't sound like enough to bring SQLite to its knees unless you're doing a huge amount of I/O and you have a slow disk.

TheWho · *Last edited by TheWho; 09-14-2014 at 01:04.*

Yes I want a solution too but I can't even think about that.
Everything was fine before the update of the new version.
And really I didn't updated SM as long time as possible on csgo (2-4 month)
The database was 2,04 MB large.

BAILOPAN · *Last edited by BAILOPAN; 09-14-2014 at 01:54.*

The question was: how many queries on average are run per second? (Or per minute, if per-second granularity is too fine)