Re: Opinions needed! Performace problems.....

Marc Scheuner (marc.scheuner_at_NO.SPAM.PLEASE.ch) wrote:

: We were using TQuery components in Delphi, that send off SQL queries
: to the central database, but we have experienced very slow performance
: because Oracle's SQL*Net seems to return way too many records; even
: when we select only one record, roughly 20 are transmitted, and with

2 quick points:
1/ from 7.3 [and on some sqlnet v1 drivers] the size of the packets sent by oracle can be varied (TSU=size) may be the syntax (?) 2/If you just want the first row in oracle you can use  where rownum=1
or just first two matches
 where rownum<3

Turloch O'Tierney Received on Fri Feb 07 1997 - 00:00:00 CST