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 #45211 is a reply to message #45210]

Mon, 22 August 2005 13:24

Michael Wallace
Messages: 409
Registered: December 2003

Senior Member

> 2) How might I go about speeding up the DataMiner querying
> process? I've read in some papers, that tuning your database
> driver is a possibile solution. But I've not found any references
> to the setup that I'm using. I'm using the Merant 3.70 32-BIT
> Oracle8 driver, to access an Oracle 9i database on a Solaris SunOS
> 5.8. Admittedly, I don't know much about drivers, but does anyone
> have any experience optimizing the performance of the Merant 3.70
> drivers? Or do you know how I might got about tuning them, or
> where I might get a newer compatible driver that is faster? Or
> would you recommend using the MS drivers instead?

I don't think the driver is the problem. I'd bet that this most likely
an Oracle tuning problem. Tuning a database, especially Oracle, is very
much an art and you often have to really study what's making it slow.
While I don't think the driver has much to do with it, it'd be good to
upgrade the driver to one that supports 9i. Take a look at
http://www.orafaq.com/faqdbapf.htm for some general info about tuning
and for specific questions, http://asktom.oracle.com is the best
resource out there. Good luck!

-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 00:57:50 PST 2025

Total time taken to generate the page: 1.44586 seconds