When using the latest release of libpqxx I did some tests to compare
the speed of prepared statement queries against the same query
being executed in a non-cached fashion. Both queries consist of the same
SQL that returns a subset of indexed x,y,z positional data. I'm seeing that
CONSISTENTLY the prepared queries are 20% slower.

Can someone confirm? The whole purpose of prepared queries is to improve
response time in frequently used queries.

Minimum round trip time to execute a query via UNIX domain socket on the
local machine is 0.8 seconds and over 1 second when using prepared statements.
This is way too long. How can I cut the time down?




http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----