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

What are jagged arrays ?

0 Answers  


Name some of the keywords used in vb.net?

0 Answers  


Compare c# and visual basic.net?

0 Answers  


Is vb net a scripting language?

0 Answers  


ColumnMapping belongs to which namespaces?

1 Answers  


In vb.net how to connect crystal report?

1 Answers  


i had attended to infosys interview on 17th april 2010...on .net..3+ experience .. to my knowledge i did well in technical and they asked me to wait for next process ..so i waited for 15 min ..later one person came and said give 7-10 days time for intimation of next process do they keep technical and hr on different day ...or i loose the interview ..am confused yaar what accuatly would be happend

2 Answers  


What is the difference between readonly variable and constant variable?

0 Answers  


Explain how to achieve polymorphism in vb.net?

0 Answers  


How to connect crystal report in vb.net ?

0 Answers  


sql satement for 2nd maximum value

15 Answers   NIIT,


What are the objects in asp.net and tell the purpose of those objects

3 Answers   Ascent, CCS, MTBC,


Categories