| Re: Speeding Up Oracle DataBase Access with IDL DataMiner [message #45210 is a reply to message #45208] |
Mon, 22 August 2005 13:44   |
Rick Towler
Messages: 821
Registered: August 1998
|
Senior Member |
|
|
Michael Wallace wrote:
>> 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!
>
I second Mike's suggestion. I would also try to narrow down the
bottleneck. Can you build your query in SQL and use another tool to
execute it?
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 want/need to go as far as db/sql tuning, you'll need to look into
more heavy duty tools. I like and use TOAD by Quest software and I'm
sure there are many others.
-Rick
|
|
|
|
comp.lang.idl-pvwave archive
Members
Search
Help
Login
Home
