[owski]

Hello,

I'm new to this sort of stuff. I'm developing a gamemode based on BlueG's MySQL plugin and have been getting some questionable performance from it, no doubt a fault of my own most likely.

I decided to benchmark my calling function:

• 1818 ticks for 100 iterations just querying - no callback provided.
• 1982 ticks for 100 iterations w/ empty callback function.

The function itself:

Код:

new string[100];	
mysql_format(g_SQL, string, sizeof(string), "SELECT * FROM `test_data` WHERE `id` = 1");
mysql_tquery(g_SQL, string, "DataThread");

Close to 2 seconds to query a name & empty int field - I have no base as to whether this is an expected speed or not. I was also getting 0.03-6 times m/s using https://sampforum.blast.hk/showthread.php?tid=218491. My question, is this an ideal speed for a gamemode to utilise efficiently?

If it helps, the cache_get_query_exec_time() was proving to be very, very little - a matter of several hundred microseconds in my callback.

I'd greatly appreciate if someone could clarify this, thanks.