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
- 6816 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
What is branching logic control in VB.NET?
Explain the advantages of vb.net?
Described strong typing and weak typing?
Tell us how many languages are supported by .net?
what is the need for dynamic controls in vb.net? i would like to know for what purpose should we create the controls dynamically? please give the answer in simple words.
What is a stream in vb.net?
how to deploy vb.net with key and evaluation time? any one can help me?
Write a VB.Net console program to check whether a number is perfect or not.
Explain private assembly?
Explain the difference between dispose and finalize()?
Is vb net a scripting language?
What is the purpose of an Assembly?
Name a feature which is common to all .net languages?
Why do we use ansi keyword?
Explain code security?
