Changeset 7185 for trunk/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Prepare Hive Database.sql

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:

• trunk/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Prepare Hive Database.sql (modified) (1 diff)

trunk/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Prepare Hive Database.sql

@@ -232 +232 @@
 GO
 
+
+ALTER TRIGGER [dbo].[tr_StatisticsDeleteCascade] ON [dbo].[Statistics] INSTEAD OF DELETE AS 
+BEGIN
+  DELETE SlaveStatistics FROM deleted, SlaveStatistics WHERE deleted.StatisticsId = SlaveStatistics.StatisticsId
+  -- should also remove UserStatistics here 
+  DELETE [Statistics] FROM deleted, [Statistics] WHERE deleted.StatisticsId = [Statistics].StatisticsId
+END
+GO
+
+
 -- ============================================================
 -- Description: Create indices to speed up execution of queries