MySQL pquery help?
#7

Quote:
Originally Posted by Battlezone
Посмотреть сообщение
Use tquery for UPDATE operations and pquery for SELECT operations.
Pquery would work here but tquery would be better in this case
On your last reply: No, he means that you have to add this line after your code
Код:
mysql_tquery(sqlConnection, query);
It depends on your needs, honestly, and the advice above shouldn't be taken as strict truth.

Queries sent with tquery are processed in the order they are sent while queries sent with pquery may not necessarily be. For tquery, imagine one pipe that the queries are put into. First in is first out. For pquery there are multiple pipes (this is where the poolsize parameter comes in) and the query is put into the pipe that is least full.

So if you have two select statements that you want to execute in order then you use tquery. Similarly, if you have multiple independent updates then you can use pquery here instead.
Reply


Messages In This Thread
MySQL pquery help? - by Jing_Chan - 11.09.2017, 20:06
Re: MySQL pquery help? - by DTV - 11.09.2017, 21:37
Re: MySQL pquery help? - by Jing_Chan - 11.09.2017, 21:48
Re: MySQL pquery help? - by Battlezone - 11.09.2017, 21:49
Re: MySQL pquery help? - by Jing_Chan - 11.09.2017, 21:50
Re: MySQL pquery help? - by Battlezone - 11.09.2017, 21:53
Re: MySQL pquery help? - by Vince - 11.09.2017, 22:20

Forum Jump:


Users browsing this thread: 1 Guest(s)