Changeset 2217 for branches/HeuristicLab.Modeling Database Backend/sources/HeuristicLab.Modeling.Database.SQLServerCompact/3.2/DatabaseService.cs

Timestamp:

07/31/09 12:11:41 (15 years ago)

Author:

mkommend

Message:

first part of performance improvements (ticket #712)

File:

• branches/HeuristicLab.Modeling Database Backend/sources/HeuristicLab.Modeling.Database.SQLServerCompact/3.2/DatabaseService.cs (modified) (7 diffs)

branches/HeuristicLab.Modeling Database Backend/sources/HeuristicLab.Modeling.Database.SQLServerCompact/3.2/DatabaseService.cs

@@ -45 +45 @@
 
       using (ModelingDataContext ctx = new ModelingDataContext(connection)) {
-        model = new Model(target, algo, PersistenceManager.SaveToGZip(algorithm.Model.Data));
+        model = new Model(target, algo);
         model.TrainingSamplesStart = trainingSamplesStart;
         model.TrainingSamplesEnd = trainingSamplesEnd;
@@ -59 +59 @@
 
       using (ModelingDataContext ctx = new ModelingDataContext(connection)) {
+        ctx.ModelData.InsertOnSubmit(new ModelData(model, PersistenceManager.SaveToGZip(algorithm.Model.Data)));
+      }
+
+      using (ModelingDataContext ctx = new ModelingDataContext(connection)) {
         foreach (string inputVariable in algorithm.Model.InputVariables) {
-          ctx.InputVariables.InsertOnSubmit(new InputVariable(model, variables[inputVariable]));          
+          ctx.InputVariables.InsertOnSubmit(new InputVariable(model, variables[inputVariable]));
         }
         ctx.SubmitChanges();
@@ -194 +198 @@
 
     public IEnumerable<IResult> GetAllResultsForInputVariables() {
-      using(ModelingDataContext ctx = new ModelingDataContext(connection) ){
-        return (from ir in ctx.InputVariableResults  select ir.Result).Distinct().ToList().Cast<IResult>();
+      using (ModelingDataContext ctx = new ModelingDataContext(connection)) {
+        return (from ir in ctx.InputVariableResults select ir.Result).Distinct().ToList().Cast<IResult>();
       }
     }
@@ -205 +209 @@
       ModelingDataContext ctx = new ModelingDataContext(connection);
       DataLoadOptions dlo = new DataLoadOptions();
-      dlo.LoadWith<ModelResult>(mr => mr.Model);
       dlo.LoadWith<ModelResult>(mr => mr.Result);
       ctx.LoadOptions = dlo;
@@ -214 +217 @@
       return results.ToList().Cast<IModelResult>();
     }
+
+    public void GetAllModelResults() {
+      ModelingDataContext ctx = new ModelingDataContext(connection);
+      DataLoadOptions dlo = new DataLoadOptions();
+      dlo.LoadWith<ModelResult>(mr => mr.Result);
+      dlo.LoadWith<ModelResult>(mr => mr.Model);
+      ctx.LoadOptions = dlo;
+
+      var results = from result in ctx.ModelResults
+                    select result;
+      results.ToList();     
+
+    }
     #endregion
 
@@ -221 +237 @@
       DataLoadOptions dlo = new DataLoadOptions();
       dlo.LoadWith<InputVariableResult>(ir => ir.Variable);
-      dlo.LoadWith<InputVariableResult>(ir => ir.Result);
-      dlo.LoadWith<InputVariableResult>(ir => ir.Model);
+      dlo.LoadWith<InputVariableResult>(ir => ir.Result);      
       ctx.LoadOptions = dlo;
 
@@ -241 +256 @@
       return ctx.Models.ToList().Cast<IModel>();
     }
+
+    public byte[] GetModelData(IModel model) {
+      using (ModelingDataContext ctx = new ModelingDataContext(connection)) {
+        var data = (from md in ctx.ModelData
+                    where md.Model == model
+                    select md);
+        if (data.Count() == 0)
+          return null;
+        return data.Single().Data;
+      }
+    }
     #endregion