high CPU usage

• • Reply

  12 years ago

  by Shobanassundaram

  Shobana Somasundaram

  Chennai, India

  Joined 12 years ago
  Hi, I have an VB.net application .In it ,datas are inserted into the mysql database every 1s.CPU usage is 50 to 60%.Is there any way to control the CPU usage of the application developed in visual studio dot net accessing mySQL database? Can anyone help me out.
  Report abuse
• • Reply

  12 years ago

  by James Crowley

  James Crowley

  London, United Kingdom

  Joined 20 years ago
  Hi, welcome to developerFusion! Are you expecting the CPU usage to be high? One of the easiest things to do would be to throttle back the number of queries you're executing - say executing one every 10 seconds instead. It will take longer, but leave the machine free to do other things. Alternatively you could look at lowering the [thread priority](http://msdn.microsoft.com/en-us/library/system.threading.thread.priority.aspx) of your application? Hope that helps?
  Report abuse
• • Reply

  12 years ago

  by konikula

  Matej Kasper

  Trutnov, Czech Republic

  Joined 15 years ago
  also you can place counter into execution cycle, and e.g. for each 14 runthrough call Application.DoEvents, but this solution suppose you want user to have application accessible, or you disable some controls for him... fastest implementation of 14 r, is IF Mod(counter, 14) = 0 Then ...
  
  Hope this is also alternative :)
  Report abuse