Symptom
- Insertion of large binary content (For example: greater than 600 MB) into a table causes performance issues (Binary Large Objects= BLOBs)
- Delays/pending in running other SQL operations.
- For example: customer trying to access lock informations from sa_locks() however it was still pending
- The Sybase Central GUI and dbisql seems to be hung.
Read more...
Environment
- SAP SQL Anywhere 16.x
- Windows
Product
SAP SQL Anywhere 16.0
Keywords
SQLA, Sybase, binary files,BLOB, performance, slowness, Sybase Central seems to be hung, sa_locks(), delays, pending , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , 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.