2021-06-05, 01:06 PM
(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