If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

DQM

Started by captainkarisma, 10 Jun 2013 08:15:28 AM

Previous topic - Next topic

captainkarisma

Hi guys,

Just wondering if anyone has succesfully implemented DQM mode with performance improvements on record counts over 50million? And also on databases other than netezza or teradata?

Cause it seems from where im standing, trying on 50million records on SQL server is pretty ordinary.

MFGF

Tha major gains are to be had in caching of data. You will likely find the initial access times of queries are pretty similar to CQM, but thereafter should be greatly improved if you are hitting some of the same data (or all of it).

You can use DQA to monitor your queries to see what database access vs cache access is happening each time.

Cheers!

MF.
Meep!