Re: Delphi - Oracle performance

From: Murali Kazhipurath <murali_at_jps.net>
Date: 1997/03/31
Message-ID: <01bc3de5$59fba380$65646464@licorice>#1/1

Please post your query along with Table and Index details.

Murali

-- 
Murali Kazhipurath
Technical Consultant
Kaustubam (Database and Internet Solutions Provider)
murali_at_jps.net
Phone # (916) 773 1918

Joost Schoonderbeek <joosts_at_worldaccess.nl> wrote in article
<N.033097.163410.84_at_solair1.inter.nl.net>...


> 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 Mon Mar 31 1997 - 00:00:00 CST