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
- 6898 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
Explain how to store decimal data in .net?
Can you please explain the difference between c# and vb.net?
What are the difference between dispose(), close(), exit(), end()? When do we use them?
Is vb net a scripting language?
Explain about Visual basic.NET culture?
How can I extract the formated word(bold,italic,underline,font,color etc) from the msword file.?
Explain the services provided by common language infrastructure.
Sir, what code to store data from vb net sql server 2008 to 2005 and at the same time in order to validate the data entered is not the same, but there have been contacts in the module. Examples such as the log table that I created, the user name as the primary key.
What is the difference between custom control and user control?
What is branching logic control in VB.NET?
What is the strong name in .net assembly?
Explain the difference between dispose and finalize()?
Why do we use byref keyword in vb.net?
Which class allows an element to be accessed using unique key?
What’s the difference between private and shared assembly?
