comp.lang.idl-pvwave archive: archive » Re: Speeding Up Oracle DataBase Access with IDL DataMiner

Home » Public Forums » archive » Re: Speeding Up Oracle DataBase Access with IDL DataMiner

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Re: Speeding Up Oracle DataBase Access with IDL DataMiner [message #45204]

Mon, 22 August 2005 15:03

Randall Skelton
Messages: 31
Registered: October 2004

Member

Hi Chris,

So I use neither the Dataminer nor Oracle but access a large
(multi-terabyte) PostgreSQL database with IDL all the time.

Is this a case of the query your doing simply taking a long time to
execute (i.e. on the server) or a case of the volume of data being
returned is very, very large? If you execute the SQL query outside of
IDL with 'explain plan query', what do you get? Some quick tutorials
are at,

http://www.adp-gmbh.ch/ora/explainplan.html
http://www.evolt.org/article/Use_Oracle_s_Explain_Plan_to_Tu ne_Your_Queries/17/2986/
http://www.oracle-base.com/articles/8i/ExplainPlanUsage.php

and there are plenty of others on the web. This will give you an idea
of how long the query itself is taking to execute on the backend
server. If it is taking too long, you'll need to look at optimizing
the query by adding indexes or clever SQLisms. If it is a data volume
issue, then you may need to restrict yourself to subset of your data to
avoid excessive network bandwidth and/or memory swapping.

The inability to use IDL during your query is typical 'blocking'
behaviour. I don't believe that the dataminer supports non-blocking
communication with the backend SQL server.

Good luck,
Randall

Report message to a moderator

[Message index]

		Re: Speeding Up Oracle DataBase Access with IDL DataMiner By: Randall Skelton on Mon, 22 August 2005 15:03
		Re: Speeding Up Oracle DataBase Access with IDL DataMiner By: Michael Wallace on Mon, 22 August 2005 13:54
		Re: Speeding Up Oracle DataBase Access with IDL DataMiner By: Rick Towler on Mon, 22 August 2005 13:44
		Re: Speeding Up Oracle DataBase Access with IDL DataMiner By: Michael Wallace on Mon, 22 August 2005 13:24

Previous Topic:	Re: Check if a point is inside a polygon mesh
Next Topic:	Re: Building Voxel arrays from png files (compression, analysis, and visualization)

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Nov 30 00:57:50 PST 2025

Total time taken to generate the page: 0.40369 seconds