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
- 6685 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
Name some of the features of C# which are not present in VB.NET?
What is global assembly cache (gac)?
List the types of authentication?
Is it necessary to have SQL server installed in your computer in order to create a service based database in vb.net?
How to retrieve images in sql server database through vb.net?
Explain the advantages of migrating to vb.net?
Compare c# and visual basic.net?
How can we remove handlers at run time?
What is the role of new keyword?
Can you please explain the difference between thread and process?
Explain about globalization?
What is internal keyword in .net framework?
What is the top .net class that everything is derived from?
Explain manifest?
What is the purpose of an Assembly?
