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.
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.