Performance with Writeback Table & Triggerd table RRS feed

  • Frage

  • Hello.
    We have got a little stange construct of AS Writeback:

    We have:

    A Fact Table with imported values

    A Writeback-Table with enterd values

    Another Table filled by a Trigger on the Writeback-Table whitch is neccessary for mirroring values entered in one account onto another account

    We want that the web application in front of the database refreshes the values ASAP values are entered on one account and being displayd on the mirrored accounts as well. We tried a few of storage methods inbetween the cube, but all different types we tried resulted in a unsatisfing performance (10-30 sec. per value)

    Thanks for any hints

    Dienstag, 14. Dezember 2010 11:46