hi , i was wonder which one is better to use for getting player data from database when he logged-in , i have about +4k user in my data base and i have to select user from this amount of users , currently i use something like this :

pInfo[playerid][score] = mysql_get ...
pInfo[playerid][skinid] = mysql_get ...
pInfo[playerid][money] = mysql_get ...

i mean i have 1 query per item! and i think this will make server LAG , should i get all items in a SELECT * query and then put them in variables? does it make any diffrent to avoid lag ? sorry i know my english is AWFUL but i guess i made my point!

One query for per item makes lag.
Get all in one query.

(2021-06-05, 11:35 AM)redex Wrote: does it make any diffrent to avoid lag?

Yes.

Also upgrade to the latest version of MySQL (r41-4) if you are still using the older version.

(2021-06-05, 12:39 PM)Radical Wrote: One query for per item makes lag.
Get all in one query.

and if i am not wrong its just related to select right? i mean only select have cache i dont use cache in others (like insert, delete or ...) so on that cases it will not make such a lag right? i mean its a little bit to hard to save the account in one query, i do the saving on player disconnect and all his stats will save there and there are a lot items that need to be saved, so its hard to put them all in one single query