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
- 6244 Views
- I also Faced
- E-Mail Answers
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
Can you please explain the difference between system.string and system.stringbuilder classes?
source code for how to login a vb.net application ?
Explain jit?
What are the various open source tool available for VB.NET?
Which dll is used for microsoft .net run time?
How can we store decimal data in .net?
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 intermediate language?
What are the advantages of an assembly?
What is the differences between dataset.clone and dataset.copy?
What is strong name in .net assembly?
Can you please explain the difference between c# and vb.net?
What is the feature which is common to all .net languages?
Explain strong name in .net assembly?
Explain how to achieve polymorphism in vb.net?
