SAP Knowledge Base Article - Preview

2478299 - SQL Anywhere Slow Fetch if numeric bind from Powerbuilder

Symptom

Slow fetch performance when Powerbuilder executes a SQL statement against a Sql Anywhere database that has a numeric bind variable.


Read more...

Environment

  • SAP SQL Anywhere - all versions
  • Power Builder v12.5

Product

PowerBuilder 12.5 ; SAP SQL Anywhere 16.0 ; SAP SQL Anywhere 17.0 ; SAP Sybase SQL Anywhere 12.0 ; SQL Anywhere 9.0 ; Sybase SQL Anywhere 10.0 ; Sybase SQL Anywhere 11.0

Keywords

hang, lag, delay, performance, bad plan, PB, SQL, SQLANY, SQLA, change, unacceptable , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , BC-SYB-PB , PowerBuilder , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.