Free cookie consent management tool by TermsFeed Policy Generator

Ignore:
Timestamp:
12/13/11 17:01:09 (13 years ago)
Author:
ascheibe
Message:

#1672

  • possible fix for the slave hang problem: don't host the service on the thread it was created on
  • added a trigger for deleting slavestatistics when statistics are deleted
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Prepare Hive Database.sql

    r6983 r7185  
    232232GO
    233233
     234
     235ALTER TRIGGER [dbo].[tr_StatisticsDeleteCascade] ON [dbo].[Statistics] INSTEAD OF DELETE AS
     236BEGIN
     237  DELETE SlaveStatistics FROM deleted, SlaveStatistics WHERE deleted.StatisticsId = SlaveStatistics.StatisticsId
     238  -- should also remove UserStatistics here
     239  DELETE [Statistics] FROM deleted, [Statistics] WHERE deleted.StatisticsId = [Statistics].StatisticsId
     240END
     241GO
     242
     243
    234244-- ============================================================
    235245-- Description: Create indices to speed up execution of queries
Note: See TracChangeset for help on using the changeset viewer.