Performance tuning for informer
This presentation is the property of its rightful owner.
Sponsored Links
1 / 22

Performance Tuning for Informer PowerPoint PPT Presentation


  • 56 Views
  • Uploaded on
  • Presentation posted in: General

Performance Tuning for Informer. PRESENTER: Jason Vorenkamp | [email protected] | 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.

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Performance tuning for informer

Performance Tuning for Informer

PRESENTER: Jason Vorenkamp| [email protected] | October 11, 2010


Performance tuning for informer

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


Performance tuning for informer

Database Server

Web Server

Client Machine

Open a Connection

Load Results

Render the Results

Execute the Query

Calculations

Arranging Data

Compute Functions


Performance tuning for informer

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


Performance tuning for informer

Do you have enough database licenses?

Has Informer reached its connection maximum?

Database Server

Open a Connection


Performance tuning for informer

Database Server

Do you have enough database licenses?

UniData : LISTUSER

UniVerse : CONFIG

Open a Connection


Performance tuning for informer

Database Server

Has Informer reached its connection maximum?

Open a Connection


Performance tuning for informer

Database Server

Has Informer reached its connection maximum?

Open a Connection


Performance tuning for informer

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


Performance tuning for informer

Database Server

Do you have initialization subroutines?

UniData / UniVerse:

Consider purchasing a connection pooling license to reduce initialization subroutine overhead.

Execute the Query


Performance tuning for informer

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


Performance tuning for informer

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


Performance tuning for informer

Database Server

Are you returning a large number of rows?

Execute the Query / Loading Results

Database Server

Web Server

Web Server


Performance tuning for informer

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


Performance tuning for informer

X

Web Server

Do you have calculated columns in your report?

60,000 RECORDS

10 ITERATIONS

Calculations

=

600,000 CALCULATIONS!


Performance tuning for informer

Is your data Sorted?

Are you normalizing on multi-values?

Is your data being grouped?

Web Server

Arranging Data


Performance tuning for informer

Web Server

Are you subtotaling/averaging groups?

Compute Functions


Performance tuning for informer

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


Performance tuning for informer

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


Performance tuning for informer

Paged:

Client Machine

Not Paged:

Are you displaying all records instead of a paged set?

Rendering the Results


Performance tuning for informer

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


Thank you any questions

Thank you! Any questions?


  • Login