🚀 go-pugleaf

Hello to Everyone,

I've been googling, trying to find different advice pages on suggestions to increase the speed of Querying / Updating. Some of them have been quite helpful. 

Such as Setting up your Cursor for ctStatic; Cursor Location clUseClient or clUseServer.

Now I've managed to reduce the query time of 5000 records from 4.5 minutes down to 1 minute... Yeah, I said 5000 records...

I have problems updating 1536 records in a decent amount of time... Right now it takes 3.25 minutes to update/insert records into the database.

We are using a Sybase Database through an ODBC Connection.

Personally, I don't understand why querying and updating is so ridiculously slow. Different programs we have updating our DB are practically instantaneous.

My method for Updating are based around using the 
SQL Exec Method.

//SQL Query Method
AssignAndQueryDateParameters(TADOQuery* QueryPointer, TDateTime SQLStartDate, TDateTime SQLEndDate)
{
   // Perform SQL Operations
   QueryPointer->Close();

   QueryPointer->Parameters->ParamByName("StartDate")->Value = SQLStartDate;
   QueryPointer->Parameters->ParamByName("EndDate")->Value = SQLEndDate;

   QueryPointer->DisableControls();
   QueryPointer->Open();
}

// Used for Updating / Inserting
// SQL Statement String has the SQL Statement with Value for 
// Updating / Inserting
ExecuteADOMethodSQLStatement(TADOQuery* QueryPointer, AnsiString SQLStatementString)
{
   QueryPointer->Close();
   QueryPointer->SQL->Clear();

   QueryPointer->SQL->Text = SQLStatementString;

   QueryPointer->ExecSQL();
}


Does anyone, have any suggestions on how I can increase the speed of the updates? Each Query / Update is executed individually. The SQL Where clause is quite specific. Hence, individual updates. 

Oh yes, there are NO DB Visual components of any sort in the application being built. 

I'm open to anything that will speed the DB process up. 
Query or Update. 

I can tolerate the slow query, but the update I can't. Anything more than a minute is painful.

Again, Any and All Suggestions / Feedback are greatly Appreciated!!!!!

Thanks,
Heinz