Re: Performance Problems with Oracle 7.3 and Microsoft ODBC

Vijay,

 One thing to check that REALLY slows things down is the ODBC tracing  option. We had a situation where some VB apps would take forever  to connect and simple queries just caused the local disk to go  nuts.

 No one knew that the Tracing parameter was turned on. Once we  turned it off things worked much better. You'll find this in  the Control-->ODBC Data Source Administrator.

 Good Luck
 Allen

Hayden Worthington, Inc.       Oracle Performance Tuning
5696 Peachtree Parkway         http://hayden.home.mindspring.com

Atlanta, Georgia 30092         White Papers, Scripts, etc.


 

Vijay Raghavacharian wrote:
>
> Guys !!
>
> We are having severe performance issues. We are having a Oracle
> database on NT server and trying to access the database from NT clients
> using the Microsoft ODBC driver. Our applciation is not transaction
> intensive. But we do search the database. In trying to connect to the
> database and creating the objects based on the data retirved from the
> database, we find the response unacceptable. Basically we fire SQL
> scripts - one after the other - to retrieve the required data. We are in
> the process of optimizing the SQL scripts - but I don't know how much
> juice we can get out of that - since most of the queries are very
> striahtforward and simple - maybe a couple of table joins. Are there any
> other paramters I need to look into.
>
> Thanks.
>
> --
> Vijay Raghavacharian
> vragha_at_ctp.com
> voice: 650-372-6246
> fax: 650-372-6200
>
> Cambridge Technology Partners (415-574-3710)
> 1300 South El Camino Real, Suite 600
> San Mateo, CA 94402
> http://www.ctp.com

-- Received on Tue Jul 14 1998 - 13:34:03 CDT