Quote:
|
Originally Posted by BAILOPAN
Sorry, I was being a little vague.
First: you should be able to concatenate multiple queries like this:
Query1; Query2; Query3; Query4; this lumping them all into one big string.
|
that's still 32 SQL statements, they are just thrown out all at the same time and run after each other. not sure how efficient that would be compared to having the 32 statements all run at the same time. Kind of defeats the purpose of multithreading ;) since you have to wait for the statements all to finish when posting one whole chunk you have to hope the map doesn't change before it's done or else your plugin won't be there to handle the task being ended.
Quote:
|
Originally Posted by BAILOPAN
Otherwise, you can delete everything, and just use the extended insert syntax each round:
INSERT INTO db VALUES (set1) (set2) (set3) (set4) (set5) ... (set32)
|
that of course works but unfortunatly won't work with our problem. the DB contains multiple entries for each player (depending on how popular the server is, generally entries for a few thousand players). only the entries for the players currently playing need to be changed.