Back

Topic

[KB517]How to optimize HDS table browsing for Dream Report

Tags: Dream Report, HDS

Other Products
14 years ago
By LM
Options
Print
Applies to:

PcVue 8.10 version onwards.
Summary:

Here is a useful trick if you need to quickly browse the table content of an HDS Database. For example in Dream Report, we browse tables each time we configure a new statistical function in a report. This can take a long time when browsing a large database (> 250 Mo).

Originator: LM
Details:

Tests were made with a 4Gb Database (200 variables).

Browsing without optimization Browsing with optimization

7 minutes

12 seconds

To optimize browsing time you must add an index in the table you want to browse.
Here below is described the way to achieve it

Screen shot were made with SQL Server Management Studio 2008 R2. 
Right click on Indexes to add a new index:

TableIndexes

Give a name for the index and click the Add… button:

IndexName

Select only the Name column for this index:

IndexColumn

Click OK and wait for the index construction:

TableIndexName

Index construction can take a long time the first time with a big database.
It can also take up space on the hard disk.

Notes:

  1. If you no longer need access to the HDS database from Dream Report the index should be deleted.
  2. This operation should only be performed with PcVue shut down!

 

Created on: 08 Dec 2011 Last update: 13 May 2024