09.06.2017, 04:17
As of now, I use mysql_tquery everywhere unless I need to do a dozen queries at once (for example, loading player data).
My intuition is that a large number of queries which are executed one after another and the results from all the queries are needed to continue further would perform better with pquery as each query get executed parallelly. However, I see several flaws in that logic. Out of the dozen queries, some of them are expensive and some of them relatively take no time. Moreover, I don't account for other effects such as SQL server's cache when queries are executed simultaneously.
I don't know when it is appropriate to use mysql_pquery. Can someone enlighten me?
My intuition is that a large number of queries which are executed one after another and the results from all the queries are needed to continue further would perform better with pquery as each query get executed parallelly. However, I see several flaws in that logic. Out of the dozen queries, some of them are expensive and some of them relatively take no time. Moreover, I don't account for other effects such as SQL server's cache when queries are executed simultaneously.
I don't know when it is appropriate to use mysql_pquery. Can someone enlighten me?