Anybody could help me please...

Most of my queries are long especially when generating reports. Querying is just fine except that my vb application is eating up my cpu (100% usage).

How can i execute query with minimal cpu usage (e.g 50% usage)? Just like other application like WINZIP that i could still extracting zip file, while working with other application without having the problem of system performance...

Maybe cpu usage is not an issue here.

Is it possible with vb6, especially in queries?

I am Using vb6 & mssql 2000...

Please help or any suggestions..

Thanks a lot!