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

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  


What is sealed class?

0 Answers  


Why do you need Lock in Visual Basic?

0 Answers   CGI,


What is writeline in vb.net?

0 Answers  


What does VS.NET contains ?

3 Answers   Infosys,


how to send data to exe file? my code has a button when i press it, an exe file will open. how can i send data as input to the exe file?

2 Answers  


List the types of authentication?

0 Answers  


What is difference between metadata and manifest?

0 Answers  


What is redim keyword and its use?

0 Answers  


What are the objects in asp.net?

0 Answers  


hey friends, Firstly I pick the records from the database into the DataGridView, Then I want that If I made any changes to the records in the GridView & Click on Update Button, Changes are Reflected into the main Database .Plz do reply back

4 Answers  


What is difference between inline and code behind?

0 Answers  


Categories