how to increase CPU usage?

  • Thread starter Thread starter pemt
  • Start date Start date
P

pemt

Dear all,

I am running a query about comparing a million items in each of two tables.
It runs so low. And the CPU is only used for 13%. I wonder if there is any
way that I could speed up the running by increasing CPU usage.

Thanks,

pemt
 
It probably isn't the CPU. Rather it's the disk access. So faster hard drives
might help.

However disk speed would be about the last thing that I'd check. Do you have
enough memory on the machine? Plenty of free hard drive space?

What does the SQL statement for the query look like? Are the fields in the
join indexed? Proper indexing would be the first thing that I'd check.
 
Thanks Jerry.

Jerry Whittle said:
It probably isn't the CPU. Rather it's the disk access. So faster hard drives
might help.

However disk speed would be about the last thing that I'd check. Do you have
enough memory on the machine? Plenty of free hard drive space?

What does the SQL statement for the query look like? Are the fields in the
join indexed? Proper indexing would be the first thing that I'd check.
Click to expand...
 
Back
Top