Free cookie consent management tool by TermsFeed Policy Generator

Changeset 505 for trunk


Ignore:
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:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/sources/HeuristicLab.Grid/Database.cs

    r504 r505  
    109109            DbCommand c = cnn.CreateCommand();
    110110            c.Transaction = t;
    111             c.CommandText = "Select Guid, CreationTime, StartTime, Rawdata from Job where Status=@Status order by CreationTime limit 1";
     111            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";
    112112            DbParameter statusParameter = c.CreateParameter();
    113113            statusParameter.ParameterName = "@Status";
Note: See TracChangeset for help on using the changeset viewer.