You should be using Direct Oracle Access components, their query component
has properties to limit the number of records fetched.
Tony
Diagoras <diagoras_at_iatriki.gr> wrote in message
news:3831873D.D7D3C437_at_iatriki.gr...
> Hi everyone,
>
> I'm developing an application with delphi 4 and oracle 8i. I use the
> native delphi VCL library (TTables) and native oracle BDE driver. The
> problem is when I use large tables (eg. 50000 records) the time needed
> to open them or move from BOF to EOF is VERY VERY large (more than 1
> min). Is there anyway to configure oracle and optimize the way that we
> access tables. For example fetch only the first 100 records and move to
> next 100 upon request. I cannot use SQL statements because of backwards
> compatibillity with other databases. I can only use the standard TTable
> component.
>
> Thanks in advance.
>
Received on Wed Nov 17 1999 - 07:59:06 CST
