1 / 22

Performance Tuning for Informer

Performance Tuning for Informer. PRESENTER: Jason Vorenkamp | support@entrinsik.com | October 11, 2010. Are you on the latest version of informer?. Version 4.1. Version 4.2. Improved Result Rendering. Optional Report Sample. Improved SQL queries. Optimized Auto-suggest.

iniko
Download Presentation

Performance Tuning for Informer

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Performance Tuning for Informer PRESENTER: Jason Vorenkamp| support@entrinsik.com | October 11, 2010

  2. Are you on the latest version of informer? Version 4.1 Version 4.2 Improved Result Rendering Optional Report Sample Improved SQL queries Optimized Auto-suggest

  3. Database Server Web Server Client Machine Open a Connection Load Results Render the Results Execute the Query Calculations Arranging Data Compute Functions

  4. Do you have the Minimum sysTemrequirements? Client Machine Database Server Web Server 2 GB recommended Disk Space: 500 MB Firefox Pentium 4® or higher Google Chrome

  5. Do you have enough database licenses? Has Informer reached its connection maximum? Database Server Open a Connection

  6. Database Server Do you have enough database licenses? UniData : LISTUSER UniVerse : CONFIG Open a Connection

  7. Database Server Has Informer reached its connection maximum? Open a Connection

  8. Database Server Has Informer reached its connection maximum? Open a Connection

  9. Do you have initialization subroutines? Are you selecting on a virtual field from large dataset? Are you returning a large number of rows? Database Server Execute the Query

  10. Database Server Do you have initialization subroutines? UniData / UniVerse: Consider purchasing a connection pooling license to reduce initialization subroutine overhead. Execute the Query

  11. Database Server 1 MINUTE 10 SECONDS SELECT PERSON WITH AGE = 18 = 1 MINUTE : 10 SECONDS Are you selecting on a virtual field from large dataset? PERSON FILE 60,000 RECORDS 5,000 RECORDS 50 RECORDS Execute the Query SELECT PERSON WITH NAME = “JASON” TOTAL

  12. Database Server 20 SECONDS 2 SECONDS SELECT PERSON WITH NAME = “JASON” = 22 SECONDS Are you selecting on a virtual field from large dataset? PERSON FILE 60,000 RECORDS 500 RECORDS 50 RECORDS Execute the Query SELECT PERSON WITH AGE = 18 TOTAL

  13. Database Server Are you returning a large number of rows? Execute the Query / Loading Results Database Server Web Server Web Server

  14. Do you have calculated columns in your report? What is the nature of the calculated columns? • Does it loop through an iteration? Web Server • Does it check an if-then-else statement? • Does it run a subroutine or function? Calculations

  15. X Web Server Do you have calculated columns in your report? 60,000 RECORDS 10 ITERATIONS Calculations = 600,000 CALCULATIONS!

  16. Is your data Sorted? Are you normalizing on multi-values? Is your data being grouped? Web Server Arranging Data

  17. Web Server Are you subtotaling/averaging groups? Compute Functions

  18. Again, is your data being grouped? Are you displaying all records instead of a paged set? Do you have a large number of columns? Client Machine Rendering the Results

  19. Client Machine Again, is your data being grouped? Group Headers are not shown in pages! 10,000 Groups = 10,000 Items to render! Rendering the Results

  20. Paged: Client Machine Not Paged: Are you displaying all records instead of a paged set? Rendering the Results

  21. Client Machine Do you have a large number of columns? 10,000 Rows x 10 Columns = 100,000 Cells 10,000 Rows x 20 Columns = 200,000 Cells Twice the information, Twice the render time! Rendering the Results

  22. Thank you! Any questions?

More Related