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
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
Can you please explain the difference between authentication and authorization?
Explain about rapid application development tool?
difference between control and component more than one differences
What do you mean by serialization and deserialization?
How many classes a dll can contain?
Which properties are used to bind a DataGridView control?
Tell me how many .net languages can a single .net dll contain?
What is visual basic.net culture?
hello thank you for replying to my question regarding adding barcode fonts in vb.net project. I have downloaded a free font and added in my vb.net project but now i dont know how to use that i need to generate barcodes can any body help me how to use those fonts these are font3of9 .i need a small code to use these fonts to generate barcode thank u!
What is the maximum size of the textbox?
What’s the difference between private and shared assembly?
What is late binding?
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.
How do you script this scenario in QTP using VB? Verify XML attributes in XML message against XSD and data mapping of fields to Oracle tables? Verify data in XML to data in a defined table?
Can you please explain the difference between value and reference types?