QueriesA major cause of performance problems are poorly structured queries. Query performance problems can be broken down into two categories: memory issues and time taken to complete the query. With memory issues, the result of the query is so large that the computer system cannot handle the result. In the time issue, the processing time of the query is much longer than needed. ENOVIA has identified some strategies to prevent query problems, which are described in detail in the "Working with Workspace Objects" chapter in the Studio Modeling Platform MQL Guide. Tcl StatementsAdditionally, you may write MQL programs that contain Tcl statements. Some of the more common problems with Tcl statements are related to Tcl syntax. The Tcl executable has strict rules regarding syntax. For a description of common Tcl syntax errors, see "Tcl Syntax Troubleshooting" in the MQL Language chapter in the Studio Modeling Platform MQL Guide. JSP DevelopmentUser-created JSP pages may access variables in a non-thread-safe way. A solution to this problem is discussed in the "Using the Context Object" topic in the Creating a Login Page chapter of the Studio Modeling Platform Programming Guide. Other common problems that occur when developing JSPs are discussed in the "Programming Notes" topic in the same guide. |