Changeset 505 for trunk

Timestamp:

08/12/08 16:35:24 (16 years ago)

Author:

gkronber

Message:

improved SQL statement to reduce I/O load of the DB (ticket #197 Use SQLite backend to store waiting engines and results instead of in-memory dictionaries)

File:

• trunk/sources/HeuristicLab.Grid/Database.cs (modified) (1 diff)

trunk/sources/HeuristicLab.Grid/Database.cs

@@ -109 +109 @@
             DbCommand c = cnn.CreateCommand();
             c.Transaction = t;
-            c.CommandText = "Select Guid, CreationTime, StartTime, Rawdata from Job where Status=@Status order by CreationTime limit 1";
+            c.CommandText = "select guid,creationtime,starttime,rawdata from job, (select id from job where status=@Status order by creationtime limit 1) as next where job.id=next.id";
             DbParameter statusParameter = c.CreateParameter();
             statusParameter.ParameterName = "@Status";