Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
![]() |
![]() |