Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Delphi - Oracle performance
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)
Received on Sun Mar 30 1997 - 00:00:00 CST
![]() |
![]() |