Changeset 9469

Timestamp:

05/08/13 14:43:44 (11 years ago)

Author:

pfleck

Message:

#2030

Task- and Plugin-data is stored in the file system instead of the database.
This is accomplished by the Filestream feature of the SQL-Server.

Fixed bug when Heal-Group does not exist.

Note: SqlServer configuration changes are necessary for Filestream feature
​http://www.codeproject.com/Articles/128657/How-Do-I-Use-SQL-File-Stream

Location:

branches/HivePerformance/sources

Files:

• HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Initialize Hive Database.sql (modified) (1 diff)
• HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Prepare Hive Database.sql (modified) (1 diff)
• HeuristicLab.Services.Hive/3.3/HiveService.cs (modified) (1 diff)

branches/HivePerformance/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Initialize Hive Database.sql

@@ -88 +88 @@
   )
 CREATE TABLE [dbo].[TaskData](
-  [TaskId] UniqueIdentifier NOT NULL,
-  [Data] VarBinary(MAX) NOT NULL,
+  [TaskId] UniqueIdentifier RowGuidCol NOT NULL,
+  [Data] VarBinary(MAX) Filestream NOT NULL,
   [LastUpdate] DateTime NOT NULL,
   CONSTRAINT [PK_dbo.TaskData] PRIMARY KEY ([TaskId])
   )
 CREATE TABLE [dbo].[PluginData](
-  [PluginDataId] UniqueIdentifier NOT NULL,
+  [PluginDataId] UniqueIdentifier RowGuidCol NOT NULL,
   [PluginId] UniqueIdentifier NOT NULL,
-  [Data] VarBinary(MAX) NOT NULL,
+  [Data] VarBinary(MAX) FileStream NOT NULL,
   [FileName] VarChar(MAX) NOT NULL,
   CONSTRAINT [PK_dbo.PluginData] PRIMARY KEY ([PluginDataId])

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

@@ -41 +41 @@
 ALTER TABLE dbo.Plugin WITH NOCHECK ADD CONSTRAINT [DF_Plugin_PluginId] DEFAULT (NEWSEQUENTIALID()) FOR PluginId;
 
-ALTER TABLE dbo.PluginData ALTER COLUMN PluginDataId ADD ROWGUIDCOL;
 ALTER TABLE dbo.PluginData WITH NOCHECK ADD CONSTRAINT [DF_PluginData_PluginDataId] DEFAULT (NEWSEQUENTIALID()) FOR PluginDataId;
 

branches/HivePerformance/sources/HeuristicLab.Services.Hive/3.3/HiveService.cs

@@ -394 +394 @@
 
         if (slave == null) {
-          var healGroup = dao.GetResources(x => x.Name == "HEAL").First();
+          var healGroup = dao.GetResources(x => x.Name == "HEAL").FirstOrDefault();
           if (healGroup != null) {
             slaveInfo.ParentResourceId = healGroup.Id;