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 #45208 is a reply to message #45204]

Mon, 22 August 2005 13:54

Michael Wallace
Messages: 409
Registered: December 2003

Senior Member

> I would install the appropriate Oracle client on your machine (you can
> at the same time install Oracle's ODBC drivers), execute that query
> using SQLplus, and look at execution time. You may find that your query
> takes just as long in which case you need to either re-think your query
> or look at tuning your db. Or, you may find that your query executes
> much faster in which case you need to look at either how you are
> performing the query in dataminer or mucking around with ODBC drivers.

If you don't already have the client software, go download it now. You
can get a lot of details through the Oracle Enterprise Manager and
SQL*Plus. Your problem could be as simple as not having a key on the
columns your searching or not having analyzed your tables in a while
(both will lead to full table scans). If you fire off a typical query
in SQL*Plus, you can then watch it in the enterprise manager and see if
it's doing. That's probably the first step to figuring this out.

-Mike

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 06:07:54 PST 2025

Total time taken to generate the page: 2.79848 seconds