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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ram
you need to check the following things:
1. Database size is very high and you are using query which
is not optimized.
2. you must be using too many joins in the query. Check the
execution plan
3. Confirm whether the CPU utilization is more from database
end or application end
http://www.interview-questions.maxmice.com
| Is This Answer Correct ? | 2 Yes | 0 No |
Explain about jagged arrarys ?
when we will use console ?
in my windows application i have to show excelwork sheetwhich is stored in the local system can any one tell me the code?
What is the class that allows an element to be accessed using unique key?
how to get sum of two numbers in vb.net?
14 Answers Factorial, Paul Infotech, Satyam,
Explain the difference between .dll extension and .exe extension files?
What is MSIL.
What are jagged arrays ?
Explain the use of new keyword?
my project run very wel in my sytem yhen i am deploying my project on client machine ,after deployment i run my project then it show " can no find server name " what i do .
Explain manifest?
How do you script this scenario in QTP using VB? Verify XML attributes in XML message against XSD and data mapping of fields to Oracle tables? Verify data in XML to data in a defined table?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)