
Make a New Friend: The Optimizer
By: Mr. Chris Ian Pollach, Gold Member on Oct 01, 2012You may sometimes find that your PowerBuilder applications that utilize the SQL Anywhere DBMS run slow during some retrieval or update operations. While this may be attributed to network load, server resource contention, a too small temporary work database, etc the most common overlooked area is often the actual Data Manipulation Language (DML) statement itself that we commonly call SQL. Even though the “S” stands for Structured, I always joke with my fellow developers and say the “S” stands for Stupid as it really depends on how properly the DBMS interprets and handles the statement as to whether you get the desired result set within the desired response time. Many application developers miss out on a key ingredient during their SQL statement development and that is having a conversation with the DBMS’s Optimizer during the system development. These informal “chats” can prevent many unwanted behaviours in production and have a profound effect on your DML coding.
Login to read the article. Not a member? Create a free account!
Keywords: SQL Anywhere Article | Technical Journal | Chris Pollach | Data Management | Data Manipulation Language | Optimizer | SQL | SQL Anywhere | Sybase Central | Sybase iAnywhere
Note: Contributors bear the sole responsibility of the content of blogs on this site. This includes both authors and commentors. ISUG-TECH takes no responsibility for the content on any blog. Report inappropriate content to ISUG-TECH directly. You can find our contact information at www.isug.com.