Financial report - Slow Data Selection

Chahade

Member
Hello all,
Does anyone know why the data selection delay to appear to the user when the financial report (custom) is run for the first time during the day? For the others executions of the day seems to bring the data selection much faster. Version: E1 9.1
SO: AS400
 
Are you using FY in your data selection?
Are you reading over one of the biggest tables in E1, the F0911?

You can get the CNC geeks to partition your F0911 based on FY, so each SQL select goes to a specific partition
 
Not a lot of info but it could be SQL packages. First iteration of the day builds one and the remaining iterations use the package. Then the packages are deleted every night.
 
Chahade,

There's a few crucial parts to your question that are missing.
- Which OS
- Which Database
- Which type of Financial Report (F0902 or F0911)
* Makes a difference based on indexing

My best guess is that you are selecting and/or sequencing your report in a non-standard way. If so, capture the initial Select Statement - and run it through some sort of SQL Analyzer.

If the first select takes for ever, and subsequent runs have improved performance - usually, that is a sign that indexing can be improved.

(db)
 
Chahade,

It could be loading a cache the first time it is run during the day and then, when it is run after that, it accesses the cache, with a faster response time.
 
Back
Top