I want to reduce my CPU Usage when I am querying the Database for records. Now

I want to reduce my CPU Usage when I am querying the
Database for records. Now my Winform App(in VB.Net)
suddenly Jumps to 100% CPU Usage when i query for records
from sql server database. I want this Usage to be less. Any
help is appreciated

Question Posted / raj

2 Answers
5836 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I want to reduce my CPU Usage when I am querying the Database for records. Now my Winform App(in V..

Answer / suresh

check if any indexes is created for that table if not
create it. Open connection and close immediately when no
longer in use.

Is This Answer Correct ?

3 Yes

0 No

I want to reduce my CPU Usage when I am querying the Database for records. Now my Winform App(in V..

Answer / ram

you need to check the following things:

1. Database size is very high and you are using query which
is not optimized.
2. you must be using too many joins in the query. Check the
execution plan
3. Confirm whether the CPU utilization is more from database
end or application end

http://www.interview-questions.maxmice.com

Is This Answer Correct ?

2 Yes

0 No

Post New Answer

More VB.NET Interview Questions

What are jagged arrarys ?

0 Answers

what is the advantage of option strict on?

0 Answers

What are option strict and option explicit?

0 Answers

What are the different types of applications supported in .net (or) .net framework?