Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Delphi - Oracle performance

Delphi - Oracle performance

From: Joost Schoonderbeek <joosts_at_worldaccess.nl>
Date: 1997/03/30
Message-ID: <N.033097.163410.84@solair1.inter.nl.net>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US