Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6818 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 enumerator?
Name and explain some of the exclusive features which are present in vb?
What is late binding and early binding?
Did vb6 support multi-threading ?
What are nested classes?
Explain option explicit?
What are the shared variables?
Explain about the ruby interface generator?
Explain some of the exclusive features which are present in vb?
What is jagged array in vb.net?
What are the different types of a stream?
Explain the services provided by common language infrastructure.
Explain how to achieve polymorphism in vb.net?
What is non_deterministic finalization?
described weak typing?
