[Tutorial] The differences between MySQL queries
#4

I may be wrong but I believe that tqueries, while executed in another thread away from the main SA-MP server thread, are still queued up behind each other; pqueries on the other hand are executed concurrently (parallel) and immediately without regard for any queue. Race conditions may ensue.

I only use pqueries for a bunch of concurrent inserts which aren't required to be in any specific order. For example, I track all money changes for every player (much like a real bank account) so whenever I need to give money to a whole team I need to perform an insert for every player in that team. In such cases pqueries come in handy.
Reply


Messages In This Thread
The differences between MySQL queries - by Nicker - 10.04.2015, 21:38
Re: The differences between MySQL queries - by Abagail - 10.04.2015, 21:43
Re: The differences between MySQL queries - by Nicker - 10.04.2015, 21:50
Re: The differences between MySQL queries - by Vince - 10.04.2015, 22:15
Re: The differences between MySQL queries - by Nicker - 10.04.2015, 22:30
Re: The differences between MySQL queries - by JeaSon - 11.04.2015, 03:25
Re: The differences between MySQL queries - by Denis1 - 12.04.2015, 06:13

Forum Jump:


Users browsing this thread: 1 Guest(s)