Slow access with Pro*C/C++
From: <mguillem_at_my-dejanews.com>
Date: Wed, 19 May 1999 09:37:13 GMT
Message-ID: <7hu0oa$nd2$1_at_nnrp1.deja.com>
[Quoted] I want to select from a C code a small number of lines (lets say 10) from a join on 2 large tables with an "order by" clause. I get good results when I seek elements at the end of the order by but very bad results at the beginning. It looks as if Oracle first loads all the results before giving me my 10 lines.
Date: Wed, 19 May 1999 09:37:13 GMT
Message-ID: <7hu0oa$nd2$1_at_nnrp1.deja.com>
[Quoted] I want to select from a C code a small number of lines (lets say 10) from a join on 2 large tables with an "order by" clause. I get good results when I seek elements at the end of the order by but very bad results at the beginning. It looks as if Oracle first loads all the results before giving me my 10 lines.
When I execute the same SQL order from SQL Plus for instance, it comes immediately, so it's not a problem of index or of database.
Any suggestion?
--== Sent via Deja.com http://www.deja.com/ ==-- [Quoted] ---Share what you know. Learn what you don't.--- Received on Wed May 19 1999 - 11:37:13 CEST