Free cookie consent management tool by TermsFeed Policy Generator

Ignore:
Timestamp:
01/22/09 00:30:46 (15 years ago)
Author:
svonolfe
Message:

Improved memory consumption, fixed bug that already calculated jobs where reset (#372)

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/sources/HeuristicLab.Hive.Server.ADODataAccess/dsHiveServer.Designer.cs

    r1165 r1166  
    75797579        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
    75807580        private void InitCommandCollection() {
    7581             this._commandCollection = new global::System.Data.SqlClient.SqlCommand[7];
     7581            this._commandCollection = new global::System.Data.SqlClient.SqlCommand[8];
    75827582            this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
    75837583            this._commandCollection[0].Connection = this.Connection;
    … …  
    75947594            this._commandCollection[2].Connection = this.Connection;
    75957595            this._commandCollection[2].CommandText = "SELECT     JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId, Serialize" +
    7596                 "dJob, Percentage\r\nFROM         Job\r\nWHERE     (ResourceId = @ResourceId)";
     7596                "dJob, Percentage\r\nFROM         Job\r\nWHERE     (JobState = \'calculating\') AND (Re" +
     7597                "sourceId = @ResourceId)";
    75977598            this._commandCollection[2].CommandType = global::System.Data.CommandType.Text;
    75987599            this._commandCollection[2].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ResourceId", global::System.Data.SqlDbType.BigInt, 8, global::System.Data.ParameterDirection.Input, 0, 0, "ResourceId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    … …  
    76007601            this._commandCollection[3].Connection = this.Connection;
    76017602            this._commandCollection[3].CommandText = "SELECT     JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId, Serialize" +
    7602                 "dJob, Percentage\r\nFROM         Job\r\nWHERE     (JobId = @Id)";
     7603                "dJob, Percentage\r\nFROM         Job\r\nWHERE     (ResourceId = @ResourceId)";
    76037604            this._commandCollection[3].CommandType = global::System.Data.CommandType.Text;
    7604             this._commandCollection[3].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Id", global::System.Data.SqlDbType.BigInt, 8, global::System.Data.ParameterDirection.Input, 0, 0, "JobId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
     7605            this._commandCollection[3].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ResourceId", global::System.Data.SqlDbType.BigInt, 8, global::System.Data.ParameterDirection.Input, 0, 0, "ResourceId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    76057606            this._commandCollection[4] = new global::System.Data.SqlClient.SqlCommand();
    76067607            this._commandCollection[4].Connection = this.Connection;
    76077608            this._commandCollection[4].CommandText = "SELECT     JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId, Serialize" +
    7608                 "dJob, Percentage\r\nFROM         Job\r\nWHERE     (JobState = @State)";
     7609                "dJob, Percentage\r\nFROM         Job\r\nWHERE     (JobId = @Id)";
    76097610            this._commandCollection[4].CommandType = global::System.Data.CommandType.Text;
    7610             this._commandCollection[4].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@State", global::System.Data.SqlDbType.VarChar, 18, global::System.Data.ParameterDirection.Input, 0, 0, "JobState", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
     7611            this._commandCollection[4].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Id", global::System.Data.SqlDbType.BigInt, 8, global::System.Data.ParameterDirection.Input, 0, 0, "JobId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    76117612            this._commandCollection[5] = new global::System.Data.SqlClient.SqlCommand();
    76127613            this._commandCollection[5].Connection = this.Connection;
    76137614            this._commandCollection[5].CommandText = "SELECT     JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId, Serialize" +
    7614                 "dJob, Percentage\r\nFROM         Job\r\nWHERE     (ParentJobId = @Id)";
     7615                "dJob, Percentage\r\nFROM         Job\r\nWHERE     (JobState = @State)";
    76157616            this._commandCollection[5].CommandType = global::System.Data.CommandType.Text;
    7616             this._commandCollection[5].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Id", global::System.Data.SqlDbType.BigInt, 8, global::System.Data.ParameterDirection.Input, 0, 0, "ParentJobId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
     7617            this._commandCollection[5].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@State", global::System.Data.SqlDbType.VarChar, 18, global::System.Data.ParameterDirection.Input, 0, 0, "JobState", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    76177618            this._commandCollection[6] = new global::System.Data.SqlClient.SqlCommand();
    76187619            this._commandCollection[6].Connection = this.Connection;
    76197620            this._commandCollection[6].CommandText = "SELECT     JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId, Serialize" +
     7621                "dJob, Percentage\r\nFROM         Job\r\nWHERE     (ParentJobId = @Id)";
     7622            this._commandCollection[6].CommandType = global::System.Data.CommandType.Text;
     7623            this._commandCollection[6].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Id", global::System.Data.SqlDbType.BigInt, 8, global::System.Data.ParameterDirection.Input, 0, 0, "ParentJobId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
     7624            this._commandCollection[7] = new global::System.Data.SqlClient.SqlCommand();
     7625            this._commandCollection[7].Connection = this.Connection;
     7626            this._commandCollection[7].CommandText = "SELECT     JobId, JobState, ParentJobId, PermissionOwnerId, ResourceId, Serialize" +
    76207627                "dJob, Percentage\r\nFROM         Job\r\nWHERE     (PermissionOwnerId = @PermissionOw" +
    76217628                "nerId)";
    7622             this._commandCollection[6].CommandType = global::System.Data.CommandType.Text;
    7623             this._commandCollection[6].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@PermissionOwnerId", global::System.Data.SqlDbType.BigInt, 8, global::System.Data.ParameterDirection.Input, 0, 0, "PermissionOwnerId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
     7629            this._commandCollection[7].CommandType = global::System.Data.CommandType.Text;
     7630            this._commandCollection[7].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@PermissionOwnerId", global::System.Data.SqlDbType.BigInt, 8, global::System.Data.ParameterDirection.Input, 0, 0, "PermissionOwnerId", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
    76247631        }
    76257632       
    … …  
    76717678        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    76727679        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
    7673         public virtual int FillByClient(dsHiveServer.JobDataTable dataTable, global::System.Nullable<long> ResourceId) {
     7680        public virtual int FillByCalculatingClient(dsHiveServer.JobDataTable dataTable, global::System.Nullable<long> ResourceId) {
    76747681            this.Adapter.SelectCommand = this.CommandCollection[2];
    76757682            if ((ResourceId.HasValue == true)) {
    … …  
    76897696        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    76907697        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
    7691         public virtual dsHiveServer.JobDataTable GetDataByClient(global::System.Nullable<long> ResourceId) {
     7698        public virtual dsHiveServer.JobDataTable GetDataByCalculatingClient(global::System.Nullable<long> ResourceId) {
    76927699            this.Adapter.SelectCommand = this.CommandCollection[2];
    76937700            if ((ResourceId.HasValue == true)) {
    … …  
    77057712        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    77067713        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
     7714        public virtual int FillByClient(dsHiveServer.JobDataTable dataTable, global::System.Nullable<long> ResourceId) {
     7715            this.Adapter.SelectCommand = this.CommandCollection[3];
     7716            if ((ResourceId.HasValue == true)) {
     7717                this.Adapter.SelectCommand.Parameters[0].Value = ((long)(ResourceId.Value));
     7718            }
     7719            else {
     7720                this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
     7721            }
     7722            if ((this.ClearBeforeFill == true)) {
     7723                dataTable.Clear();
     7724            }
     7725            int returnValue = this.Adapter.Fill(dataTable);
     7726            return returnValue;
     7727        }
     7728       
     7729        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     7730        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     7731        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
     7732        public virtual dsHiveServer.JobDataTable GetDataByClient(global::System.Nullable<long> ResourceId) {
     7733            this.Adapter.SelectCommand = this.CommandCollection[3];
     7734            if ((ResourceId.HasValue == true)) {
     7735                this.Adapter.SelectCommand.Parameters[0].Value = ((long)(ResourceId.Value));
     7736            }
     7737            else {
     7738                this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
     7739            }
     7740            dsHiveServer.JobDataTable dataTable = new dsHiveServer.JobDataTable();
     7741            this.Adapter.Fill(dataTable);
     7742            return dataTable;
     7743        }
     7744       
     7745        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
     7746        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
     7747        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
    77077748        public virtual int FillById(dsHiveServer.JobDataTable dataTable, long Id) {
    7708             this.Adapter.SelectCommand = this.CommandCollection[3];
     7749            this.Adapter.SelectCommand = this.CommandCollection[4];
    77097750            this.Adapter.SelectCommand.Parameters[0].Value = ((long)(Id));
    77107751            if ((this.ClearBeforeFill == true)) {
    … …  
    77197760        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
    77207761        public virtual dsHiveServer.JobDataTable GetDataById(long Id) {
    7721             this.Adapter.SelectCommand = this.CommandCollection[3];
     7762            this.Adapter.SelectCommand = this.CommandCollection[4];
    77227763            this.Adapter.SelectCommand.Parameters[0].Value = ((long)(Id));
    77237764            dsHiveServer.JobDataTable dataTable = new dsHiveServer.JobDataTable();
    … …  
    77307771        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
    77317772        public virtual int FillByState(dsHiveServer.JobDataTable dataTable, string State) {
    7732             this.Adapter.SelectCommand = this.CommandCollection[4];
     7773            this.Adapter.SelectCommand = this.CommandCollection[5];
    77337774            if ((State == null)) {
    77347775                this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
    … …  
    77487789        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
    77497790        public virtual dsHiveServer.JobDataTable GetDataByState(string State) {
    7750             this.Adapter.SelectCommand = this.CommandCollection[4];
     7791            this.Adapter.SelectCommand = this.CommandCollection[5];
    77517792            if ((State == null)) {
    77527793                this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
    … …  
    77647805        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
    77657806        public virtual int FillBySubjobs(dsHiveServer.JobDataTable dataTable, global::System.Nullable<long> Id) {
    7766             this.Adapter.SelectCommand = this.CommandCollection[5];
     7807            this.Adapter.SelectCommand = this.CommandCollection[6];
    77677808            if ((Id.HasValue == true)) {
    77687809                this.Adapter.SelectCommand.Parameters[0].Value = ((long)(Id.Value));
    … …  
    77827823        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
    77837824        public virtual dsHiveServer.JobDataTable GetDataBySubjobs(global::System.Nullable<long> Id) {
    7784             this.Adapter.SelectCommand = this.CommandCollection[5];
     7825            this.Adapter.SelectCommand = this.CommandCollection[6];
    77857826            if ((Id.HasValue == true)) {
    77867827                this.Adapter.SelectCommand.Parameters[0].Value = ((long)(Id.Value));
    … …  
    77987839        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]
    77997840        public virtual int FillByUser(dsHiveServer.JobDataTable dataTable, global::System.Nullable<long> PermissionOwnerId) {
    7800             this.Adapter.SelectCommand = this.CommandCollection[6];
     7841            this.Adapter.SelectCommand = this.CommandCollection[7];
    78017842            if ((PermissionOwnerId.HasValue == true)) {
    78027843                this.Adapter.SelectCommand.Parameters[0].Value = ((long)(PermissionOwnerId.Value));
    … …  
    78167857        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, false)]
    78177858        public virtual dsHiveServer.JobDataTable GetDataByUser(global::System.Nullable<long> PermissionOwnerId) {
    7818             this.Adapter.SelectCommand = this.CommandCollection[6];
     7859            this.Adapter.SelectCommand = this.CommandCollection[7];
    78197860            if ((PermissionOwnerId.HasValue == true)) {
    78207861                this.Adapter.SelectCommand.Parameters[0].Value = ((long)(PermissionOwnerId.Value));
Note: See TracChangeset for help on using the changeset viewer.