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

From: Luke <luke_at_tigaris.com>
Date: 1997/02/06
Message-ID: <01bc13ff$6cca0b60$132e44c6@primenet.primenet.com>#1/1

Use the ROWSET SIZE parameter within the BDE configuration for Oracle to indicate the number of records you want returned with each operation.

Marc Scheuner <marc.scheuner_at_NO.SPAM.PLEASE.ch> wrote in article
>
> 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
> all the acknowledge traffic going back and forth, we have way too much
> traffic on the slow WAN and therefore unacceptable performance.
Received on Thu Feb 06 1997 - 00:00:00 CST