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

Filed under:
|
|

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

Related posts about database

Related posts about indexes