Re: Delphi - Oracle performance

Joost Schoonderbeek wrote:
>
> I've writted a database application in Delphi on a Oracle database with about
> 200.000 surnames. No fancy relations, just a simple (large?) database.
> Accessing the database with a TDBGrid, TDataSource and TTable/TQuery is not
> quick enough. While standing on record 150.000 three times PageUp hangs the
> computer for almost 1 minute.
> Yes, I've created an index on the right fields. It seems that Oracle can't use
> the Index while scrolling backwards ???
> Does anybody know wheather this is the problem or am I asking the impossible.
>
> Joshua Schoonderbeek
> Please respond by mail (too)

When you go against a server, you should not do the same things you would do against a desktop database. One of those things is building large resultsets. Most servers only allow you to navigate forward, which means that you have to refetch from the beginning if you want to navigate backwards. The proper way to navigate through a large table is to find some limiting criteria (like starting letters, etc.) and fetch small subsets of the data you are interested in.

It's not Oracle's fault, it's just more difficult to interact with a server in a way that is intuitive to the user.

Regards,

Karl Received on Sun Mar 30 1997 - 00:00:00 CST