Re: Oracle vs. Sybase

Jon Winchester wrote:
>
> A. S. Williams wrote:
> >
> > To some this will appear to be a repost, but please be patient with me. I
> > am trying to justify a choice between these two products for a fully
> > relational database product to use for a large customer base, large user
> > base corporate application with a requirement of high reliability. I would
> > appreciate any comments concerning perceived or known limitations with
> > either product that can be provided. I have heard of some limitations, but
> > am trying to get more details and can't even find a web site with objective
> > reviews of these products. Thanks in advance for your participation...
> >
> > A. S. Williams
>
> 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.
>
> Jon

Something is strange here. Sybase doesn't just create stored procedures. It sounds like some foreign application is doing it.

I'm curious, get in touch if you want to discuss more

matt townsend
mtownsend_at_nlight.com Received on Thu Jun 12 1997 - 00:00:00 CDT