Re: Oracle 7.3 on Netware versus Delphi

Not only does it bring the whole table, it must query the data dictionary for the structure of the table so that it can build a SQL statement to get the data that Oracle can read.

You may also want to look at the MaxRows setting within the BDE configuration (assuming you are using the the CLient Server version of Delphi). Read the help file first though.

"David Lord" <lordd_at_dial.pipex.com> wrote:

>The TTable objects in delphi 1.0 brings the WHOLE table across the network
>to the client (ie. if you monitor the server, you will see that it runs
>"select * from my_table"). To avoid this, use SQL queries rather than
>Tables.
 

>Orlando Júnior <unicnpd_at_nutecnet.com.br> wrote in article
><01bcac2d$889e1ae0$1026f1c8_at_junior>...
>>
>> Hi all!!
>>
>> I work in Brazil and have a problem with acess time to tables in Oracle
>> 7.3 in Netware 3.12. I work with Delphi 1.0, SQLNET 2.3 in a Windows 95
>> client.
>>
>> The time to Table.Open whith Table component is larger 20 seconds.
>> Otherwise, if I uses a query component, with select * from table, the
 time
>> is 1 second.
>>
>> Any people already have a problem as it?? please, help-me!
>>
>> Thanks!
>>
>>
Received on Thu Aug 21 1997 - 00:00:00 CDT