[Sew_Sumi]

Quote:

Originally Posted by Banditukas But i don't really understand... How queries is working then? when you send query from server, server is waiting a response and then do in callback now how threaded queries working, but when the first query is calling and getting response if in same time will be second query then it will have to wait until the first complete, get response and then it can be perfomed. But if more queries then and more waiting for complete and this make longer saving and other things.

Rather than open the whole file, reading it, and selecting the value I need, query the SQL server for the value I want and it'll respond faster.

And being that it is SQL, it can also sort, filter, and do everything that a file based system can do, much faster and without any significant load on the server.

The queries aren't requiring the player to be online to have their files open so they can be edited.



Where as you would have an issue if you put a SQL server in EU, and used a US server to play on/query from; if you plan your install and placement of those servers better you'll get good results. (No delay and no packet loss in the SQL query).