|
|
| 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
|
|
|
|
| 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
|
|
|
|
| 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
|
|
|
|
comp.lang.idl-pvwave archive
Members
Search
Help
Login
Home
