It is required to prefetch data for dashboard components whose SQL query takes longer to execute. Instead of the SQL query being executed every time the dashboard is opened, on-demand data prefetching is performed.
Prefetching stores data in dedicated tables.
There are two options available for data prefetching:
- Click Prefetch Data in the Administration Panel, or
- Run PANTHEON with the parameter /DSH.
Using Prefetch Data in the Administration Panel
For prefetching click Prefetch Data in the
Administration Panel | ZEUS | Dashboard.
 |
If no errors occured during prefetching, the message "Data prefetching completed successfully." is displayed.
|
Run PANTHEON with the parameter /DSH.
Running PANTHEON with the parameter /DSH refreshes data in the default database.
Example:
"c:\Program Files\DataLab\Pantheon55_SQL.exe" /L=UU:abc /DSH
To prefetch data use parameter /DSH=ALL whenever there are multiple databases located on the server. This prefetches data in all databases. The example below assumes that the user UU with the password abc exists in all databases.
Example:
"c:\Program Files\DataLab\Pantheon55_SQL.exe" /L=UU:abc /DSH=ALL
To refresh components in certain databases only, specify databases in brackets and separat them using semi-colons.
Example:
"c:\Program Files\DataLab\Pantheon55_SQL.exe" /L=UU:abc /DSH=ALL(DB1;DB2;DB3)
To refresh components in multiple databases with different users, list the databases as above, but specify the user name and password separated by colons after each database.
Example:
"c:\Program Files\DataLab\Pantheon55_SQL.exe" /L=UU:abc /DSH=ALL(DB1:user1:pass1;DB2:user2;DB3)
Here, user1/pass1 is used to log on to the database DB1, user2 logs on to DB2 without a password, and for DB3 the user name/password specified with the /L parameter is used.
Use command line parameter /L to log on with the specified user name and password. Use /DSH to prefetch data.
For more information see command line parameters.
PANTHEON Guide:
- ZEUS (settings in the Administration Panel)
Related topics: