Time out problem

VB Application performs a large number of queries to an SQL server in all th
e
process takes around 6 hours to complete. Why should the CPU show only 4%
activity for this process.

Regards
Phil

Its a common misconception that a CPU has to run at 100% to be running at
its fastest. There are other factors that mean that the CPU is in fact
waiting most of the time for the data.

The data retrieval to memory isn't usually handled by the CPU, as its
handled by the UDMA controller, and as hard drives are extremely slow
compared to the CPU and memory operating speeds, the CPU can't use all of
its clock cycles to perform the operations.

If in fact the CPU is only performing at 4%, its that it can't access the
data fast enough. One way to combat this is to install a RAID system, which
allows for faster data retrieval.

Andy