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
Answers were Sorted based on User's Feedback
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 |
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 |
What are the shadow variables?
What are the two main parts of .net?
how to save items in gridview and the form name is vendor rating?
Define cls?
How to Insert a TextBox value in to Sql database using VB.Net coding?
Explain how to achieve polymorphism in vb.net?
how to deploy vb.net with key and evaluation time? any one can help me?
In Datagrid after adding row, how you will assign the value for each cell to currently added new row?
What are the shared variables?
when do we need a multiple document interface?
I have an opening for "APRIMO" Developer in Mumbai Location
When do you use virutal keyword?