[asherkin]

Originally Posted by Potato Uno Is there a reason why non-threaded queries exist then? Everyone says not to use them like as if it's AIDS (for good reason too). Can't we make the API use threaded by default, and only use non-threaded as a fallback? (Rather than allowing people to voluntarily use them?)

The new MethodMap SQL API only exposes threaded queries.

[friagram]

Originally Posted by Potato Uno Is there a reason why non-threaded queries exist then? Everyone says not to use them like as if it's AIDS (for good reason too). Can't we make the API use threaded by default, and only use non-threaded as a fallback? (Rather than allowing people to voluntarily use them?)

Non threaded queries lock up the gameserver, so its best not to use them. I have never found a situation where it was required by design to use non threaded queries.

[VoiDeD]

Originally Posted by Potato Uno Is there a reason why non-threaded queries exist then? Everyone says not to use them like as if it's AIDS (for good reason too). Can't we make the API use threaded by default, and only use non-threaded as a fallback? (Rather than allowing people to voluntarily use them?)

Eventually.™

[Puppetmaster]

It does seem that using non-threaded queries is easier as its a quick & dirty solution. I personally have it that way in my ranks plugin because I do not maintain a local copy of player data. While this is probably against best practice it was quick to code rather than maintaining a copy of a slice of the DB. For my 5v5 server it only takes a few milliseconds at the end of each round to do it so I did not bother threading it. On the other hand my map render plugin was quickly coded in a few short hours and makes ok-ish use of threads and is seemingly lag free since it also does not hold a local copy of the database.

Since my server only has 512MB of ram is it really such a good idea to have a local copy of the DB in sourcemod and doing my functions on that and updating in a thread rather than letting my MySQL server handle it by using non-threaded queries? Wouldn't that increase the memory usage on my server by a fair bit?

[friagram]

Offloadig the sql stuff to an offsite server is going to improve performance and decrease memory usage... But it will have to be threaded. Even mysql on the same machine can cause you some problems, as queries are not instant.