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 / 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 |
Post New Answer View All Answers
Explain how to send xml file on server using http protocol?
What is the advantage of using system.text.stringbuilder over system.string?
What is an application domain? how they get created?
Explain trace in vb.net?
What is the source code for display the picture in button click event?
List the different types of assembly?
How a base class method is hidden?
thak you Mr Govind for replying to my question. My next question is that how to retrieve image stored in an SQL server table and assign it to any image control or picture control using VB.net
What is multiple form in vb?
Explain and brief about rapid application development tool?
Explain the use of option explicit?
What is difference between metadata and manifest?
What are option strict and option explicit?
what is difference between web.config and machine.config and where it will be ?
Explain some of the exclusive features which are present in vb?