Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

Answers were Sorted based on User's Feedback



I want to reduce my CPU Usage when I am querying the Database for records. Now my Winform App(in V..

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

I want to reduce my CPU Usage when I am querying the Database for records. Now my Winform App(in V..

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

Post New Answer

More VB.NET Interview Questions

Explain about jagged arrarys ?

0 Answers  


when we will use console ?

3 Answers  


in my windows application i have to show excelwork sheetwhich is stored in the local system can any one tell me the code?

1 Answers  


What is the class that allows an element to be accessed using unique key?

0 Answers  


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?

0 Answers  


What is MSIL.

8 Answers   HDFC,


What are jagged arrays ?

0 Answers  


Explain the use of new keyword?

0 Answers  


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 .

0 Answers  


Explain manifest?

0 Answers  


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?

0 Answers   Perot Systems,


Categories