Skip to Content
0
Former Member
Feb 19, 2010 at 03:11 PM

Performance issue with sybase stored procedures

11 Views

Hi,

I'm using a stored procedures to trace a chart. It's a Sybase 12.5 SP.

When I execute this SP with Sybase Open Client, it takes about 10sec to run.

However when i use CR Client to create he chart, it takes about 1m30 to execute the same procedure.

The SP returns about 300 rows. I use the native connection by defautl but I tried ODBC connection but there is no changes.

Can someone help me fixing this issue?

Regards