Changeset 9469


Ignore:
Timestamp:
05/08/13 14:43:44 (6 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:
3 edited

Legend:

Unmodified
Added
Removed
  • branches/HivePerformance/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Initialize Hive Database.sql

    r9123 r9469  
    8888  )
    8989CREATE TABLE [dbo].[TaskData](
    90   [TaskId] UniqueIdentifier NOT NULL,
    91   [Data] VarBinary(MAX) NOT NULL,
     90  [TaskId] UniqueIdentifier RowGuidCol NOT NULL,
     91  [Data] VarBinary(MAX) Filestream NOT NULL,
    9292  [LastUpdate] DateTime NOT NULL,
    9393  CONSTRAINT [PK_dbo.TaskData] PRIMARY KEY ([TaskId])
    9494  )
    9595CREATE TABLE [dbo].[PluginData](
    96   [PluginDataId] UniqueIdentifier NOT NULL,
     96  [PluginDataId] UniqueIdentifier RowGuidCol NOT NULL,
    9797  [PluginId] UniqueIdentifier NOT NULL,
    98   [Data] VarBinary(MAX) NOT NULL,
     98  [Data] VarBinary(MAX) FileStream NOT NULL,
    9999  [FileName] VarChar(MAX) NOT NULL,
    100100  CONSTRAINT [PK_dbo.PluginData] PRIMARY KEY ([PluginDataId])
  • branches/HivePerformance/sources/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Prepare Hive Database.sql

    r7916 r9469  
    4141ALTER TABLE dbo.Plugin WITH NOCHECK ADD CONSTRAINT [DF_Plugin_PluginId] DEFAULT (NEWSEQUENTIALID()) FOR PluginId;
    4242
    43 ALTER TABLE dbo.PluginData ALTER COLUMN PluginDataId ADD ROWGUIDCOL;
    4443ALTER TABLE dbo.PluginData WITH NOCHECK ADD CONSTRAINT [DF_PluginData_PluginDataId] DEFAULT (NEWSEQUENTIALID()) FOR PluginDataId;
    4544
  • branches/HivePerformance/sources/HeuristicLab.Services.Hive/3.3/HiveService.cs

    r9434 r9469  
    394394
    395395        if (slave == null) {
    396           var healGroup = dao.GetResources(x => x.Name == "HEAL").First();
     396          var healGroup = dao.GetResources(x => x.Name == "HEAL").FirstOrDefault();
    397397          if (healGroup != null) {
    398398            slaveInfo.ParentResourceId = healGroup.Id;
Note: See TracChangeset for help on using the changeset viewer.