Re: Performance of Parser?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On 13-Jan-07, at 7:24 PM, Tom Lane wrote:

Jignesh Shah <J.K.Shah@xxxxxxx> writes:
The appserver is basically using bunch of prepared statements that the
server should be executing directly without doing the parsing again.

Better have another look at that theory, because you're clearly spending a lot of time in parsing (operator resolution to be specific). I think
your client code is failing to re-use prepared statements the way you
think it is.

This is exactly what is happening. The driver needs to cache statements for this to work.

Dave

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
       message can get through to the mailing list cleanly




[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux