[Kailo]

I write plugins using MySQL, but then data sends in base on server occurs 0.5 s lags. Then i off data send lags off. Why it happen? Any ways to store data without MySQL? Data gets only on plugin start. Game - CSGO. Data - 7x (10x (int, string(40), string(1, float)).

[KissLick]

Do you use threaded mysql?

[Kailo]

I use SQL_FastQuery for sending data.

[aexi0n]

You need to use threaded MySQL queries or your server will lag every time you send a query.
https://wiki.alliedmods.net/SQL_%28S...g%29#Threading

[KissLick]

Originally Posted by aexi0n You need to use threaded MySQL queries or your server will lag every time you send a query. https://wiki.alliedmods.net/SQL_%28S...g%29#Threading

Yep

[Mathias.]

just to understand quickly, fastquery will send a query to sql and will freeze the server proccess until it done, threaded sql will send the query into an thread so the game proccess is not affected and it will call a function callback when done.

[ClassicGuzzi]

Originally Posted by Black-Rabbit just to understand quickly, fastquery will send a query to sql and will freeze the server proccess until it done, threaded sql will send the query into an thread so the game proccess is not affected and it will call a function callback when done.

Exactly and you can send one argument to that callback.

Also if you are just checking for errors on the callback, you could reuse the same function multiple times.

[Kailo]

I understand. I alredy fix it. Solved.