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.

I seriously doubt that this is an issue with Oracle. It probably has more to do with your Delphi app and how it populates the grid.

• TRW -- ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| | Tim Witort || He is not silent. He is not | | trw_at_medicalert.org || whispering. We are not quiet | | || we are not listening. | | Pin: TZ, only one :^( || - Out of the Grey | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||