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
- 6899 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
Which is the base class for all the classes in .net framework?
Explain how does the xmlserializer work?
What is enumerator?
Explain the difference between .dll extension and .exe extension files?
Can you please explain the difference between dataset and datareader?
What is the use of assembly?
What is normal jit?
Name some of the features of C# which are not present in VB.NET?
How many ways the function can return values?
How to view an assembly?
write a program to develop a graphic user interface application of marks book with students names and their names.the program should show the following options main menu,add student details,display student details,maximum mark and minimum mark.
Define cls?
Can you please explain the difference between vb and vb.net?
What is the difference between value and reference types?
List the different types of assembly?
