Re: Delphi - Oracle performance

Hi,

If your using Delphi2, then you can limit the number of rows returned by a query at any one time. This is one way to achieve what you want.

However, if the user performs a query that attempts to display 200,000 records then the data that you are displaying is meaningless. Try to discover what information your user needs to gain from this information, and tailor your application to provide this information, rather than the raw data that the user might use to get this information. This is the best way of proceeding, and forms the basis of most computer human interaction books.

Hope this helps.

Bryan

-- 
Bryan Dollery BSc(Hons)
ByteSmart Systems Ltd.


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)

>