Problem with Sybase performance

We had a strange problem with Sybase performance: the query that should have used indexes while executing did not, and as a result took forever to execute.  For some reason the time stamp was not treated as date type when set from the code. So the easiest solution was to add ?DYNAMIC_PREPARE=true to the connection string, and that solved the problem.

Leave a Reply

You must be logged in to post a comment.