Re: Oracle vs. Sybase

Hi Jon

This is not a reply to the original post, but maybe a suggestion to your build up of stp's. I don't know whether you have done this already, but there is an option in your ODBC driver to set which does not cause stp to be created..You should see a difference in performance.

For MS SQL server driver - under options, deselect checkbox for "Generate stp for prepare statement"

For Sybase SQL server driver - under Advanced, Performance set Prepare Method to "2-Full"

I have had this problem with another product and I could not believe the performance improvement I got.

Cheers
Matt Van Rensburg
mattvan_at_usa.net

On Thu, 12 Jun 1997 10:11:17 -0400, Jon Winchester <jon_at_wh.net> wrote:

>
>We tried to port out application to Sybase and experienced some strange
>problems. The one killer that we were never able to clear up, even after
>bringing in a Sybase expert consultant was that it appeared to convert
>every SQL that we sent to it from our app (VB via ODBC calls direct through
>ODBC API) into system stored procedures and then execute them.
>
>While the performance was good, it would build up these stored procedured
>and would begin to slow down. The only fix that we found was to shut down
>the server daily to clear them out.
>
>I am sure there is a way to work with the server so that this does not
>happen, but we (admitted Sybase non-experts) were unable to find it as
>was our supposed Sybase expert.
>
Received on Fri Jun 13 1997 - 00:00:00 CDT