Re: 4.1.8 summary: C-API/ODBC remote performance slow, Prepared Statements stall server, subselects ???, OR clauses in SELECTS
"Remote" Performance should not be 25% of Local performance on fast network.
First question is how many connections are you testing ? If it is single connection latency can be the problem. With 0.5ms latency you can get 2000 round trips per second which would
limit you to some 1000 queries/sec if you have 2 round trips per query (depending on various factors it can be much more)
I would also check connection via TCP/IP vs Unix Socket (on Linux) - TCP/IP can be 20% faster on Local host especially for small queries.
Subselects for some cases internally use temporary table. In such case they are mainly for convenience. It also allows one to run less statements which can be significant part of the load for simple queries.
In your case of splitting the query the thing is for full query only key prefix on (a) column can be used while for several query (or one query with UNION instead of OR) longer prefix could be used.
Subject
Views
Written By
Posted
6876
December 20, 2004 06:10AM
3155
December 20, 2004 06:23AM
2729
December 28, 2004 03:59PM
3819
December 31, 2004 12:36AM
Re: 4.1.8 summary: C-API/ODBC remote performance slow, Prepared Statements stall server, subselects ???, OR clauses in SELECTS
2848
December 31, 2004 01:56AM
2276
January 04, 2005 05:11AM
2373
January 05, 2005 07:42PM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.