Database

sujithkumarsl wrote:

Also implemented locks to avoid conflict. But unfortunately that didn't improved the performance.

// Change
              WaitHandle[] resetEvents = new WaitHandle[GeCommonConfig.ThreadCount];
              for (int index = 0; index < GeCommonConfig.ThreadCount; index++)
              {
                  resetEvents[index] = new AutoResetEvent(false);
                  ThreadDetails objThreaddetails = new ThreadDetails((AutoResetEvent)resetEvents[index], index.ToString());
                  ThreadPool.QueueUserWorkItem(new WaitCallback(StartProcessing), objThreaddetails);
              }
              WaitHandle.WaitAll(resetEvents);

protected static bool ExecuteQuery(string strQuery, DataSet dataSet, Object lockObject)
{
        try
        {
            lock (lockObject)
            {
                return ExecuteQueryEx(strQuery, dataSet);
            }
        }
        catch
        {

        }
    return false;
}

sujithkumarsl wrote:

WaitHandle.WaitAll(resetEvents);

startProcessing()
{
  Heavy Databse operations are doing here ( including insert, delete, select, update)
  executeQuery();
}