Delphi 4 & Oracle8i

From: Diagoras <diagoras_at_iatriki.gr>
Date: Tue, 16 Nov 1999 18:33:01 +0200
Message-ID: <3831873D.D7D3C437@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 Tue Nov 16 1999 - 10:33:01 CST