Re: Oracle 7.3 on Netware versus Delphi

From: David Lord <lordd_at_dial.pipex.com>
Date: 1997/08/20
Message-ID: <01bcada9$ec62afa0$54f382c1@fmc-systems-5>#1/1

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 Wed Aug 20 1997 - 00:00:00 CDT