mysql question

[Weii.]

I have a question if I add a mysql into looping function will cause server to lag ? I can't realy test it, but if there would be 50 players on server will server lagg?

Code looks someting like that:

function test() 
for index, player in ipairs(getElementsByType("player")) do 
dbQuery(con, "UPDATE ....") 
end 
end 

[IIYAMA]

Depends how strong the server is, but yes it will use more memory then normal.

[Baseplate]

Depends how strong the server is, but yes it will use more memory then normal.

Besides, why to use "UPDATE" syntax with dbQuery?

[Weii.]

Thanks IIYAMA!

Besides, why to use "UPDATE" syntax with dbQuery?

I just use it for this example, I use exports to my mysql resource...

[WhoAmI]

To inserting/updating things use dbExec.

[IIYAMA]

I have no knowledge of mysql, only lua.

[Noki]

Instead of using a loop, you can trigger a server-side event from client-side, and pass the local player over.