Re: Delphi 4 & Oracle8i

From: Ulrik Hoffmann <ulrik_at_hoffmann-kiel.de>
Date: Tue, 16 Nov 1999 20:31:20 +0100
Message-ID: <80sbev$17ht4$1@fu-berlin.de>

You should better use TQuery-Components instead of TTable. A TTable-component always loads the whole table with all of its data. With a tquery, you always get the data from the server you need.
I'm not sure if the BDE does it, but some of other native bde-replacements for Delphi and Oracle (like DOA on http://www.allroundautomations.nl) are only fetching the records needed for display. If a user e.g. scrolls in a grid, the next record where fetched.

Bye
Uli

>
> 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 - 13:31:20 CST