Problem performance datawarehouse with lots of indexes
Posted
by Lieven Cardoen
on Stack Overflow
See other posts from Stack Overflow
or by Lieven Cardoen
Published on 2009-12-10T09:02:58Z
Indexed on
2010/05/18
2:40 UTC
Read the original article
Hit count: 389
Our product takes tests of some 350 candidates at the same time. At the end of the test, results for each candidate are moved to a datawarehouse full of indexes on it. For each test there's some 400 records to be entered in datawarehouse. So 400 x 350 is a lot of records. If there are not much records in the datawarehouse, all goes well. But if there are already lots of records in the datawarehouse, then a lot of inserts fail...
Is there a way to have indexes that are only rebuild at the end of the day or isn't that the real problem? Or how would you solve this?
© Stack Overflow or respective owner