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
- 2 Answers
- 5808 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Explain the difference between .dll extension and .exe extension files?
What is private assembly?
What is the Advantage of vb.net over vb
Which class allows an element to be accessed using unique key?
When do you use virutal keyword?
Can you please explain the difference between int and int32?
Explain namespace?
How many languages are supported by .net?
Explain some of the exclusive features which are present in vb?
Explain the difference between datatable and dataset?
What is difference between import system.data.sqlclient,system.data.oledb?
What are the advantages of VB.NET?
What keyword is used to accept a variable number of parameter in a method?
Explain the difference between int and int32?
What do you mean by serialization and deserialization?
