[RESOLVED] VB6 Performance

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!

are you using Stored procedures in MSSQL Server? Use indexes to your tables for speedup executing of your queries.

I don't know of any way to control CPU usage of your process. You can change thread priority which can make other apps run smoother along with yours, but other than that I'm not sure.

Windows seems to utilize all CPU available during a loop or other process. For example, if nothing else is requesting CPU cycles Windows will give your program 100%. If you have 2 instances of your program running, you'll notice each will use about 50%.

I don't use stored procedures but I do creating indexes....
I don't have maybe the problem with queries performance coz my longest query took less than a minute. In fact, the query is running very fast but choking my system. What i want now (it could be funny) is to make it slower just like a speed of a browser. Browser is slow isn't it? But i could open many windows as long as my memory could handle...

Is it possible with vb6?

Anyway, thanks for all of you guys!

Upgrade CPU to the dual/quad processor versions, unless you intend to write your own mssql dll.

Post your code as it could be something that you coded that is adding extra slowness.

create stored procedure in your database that you can call from vb

Are you sure it is your application? Do you have any potential network issues?

Duplicate threads merged

:) Thanks a lot guys.

My problem has been resolved. I can run queries without choking my CPU.

I have found the answer ==> http://support.microsoft.com/kb/262311

Thanks a lot!

Cool :) Could you please resolve the thread ;) Click Thread Tools --> Mark Thread Resolved