| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> 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.
It's strange (IMHO), I have about 150000 records in one big table and about 10000 in 5 other tables and the performance is perfect. I've used a TQuery in my program because the TTable was slower.
Environment : Oracle 7.1 on WinNT + Delphi 1.0
 |
 |