Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Eric den Doop
  Where is Eric den Doop?
 Houten
 Netherlands
 Eric den Doop
 To: cubi tran
  Where is cubi tran?
 rochester
 New York - United States
 cubi tran
 Tags
Subject: RE: CPU and memory usage
Thread ID: 78970 Message ID: 78973 # Views: 2 # Ratings: 0
Version: Visual FoxPro 8 Category: General VFP Topics
Date: Tuesday, October 11, 2005 5:39:34 PM         
   


> > > Currently, when my table is getting bigger, my VFP application runs slow when I have other applications run at the same time (and vice versa). I noticed that VFP use all the computer resources (especially CPU) to run so other applications have to wait. Is there any way to specify the CPU usage as well as the memory usage for the VFP?
> >
> > What is your app doing when it's taking up all resources? Perhaps you can add some optimizations to your code.
> > There's some SYS() functions that may help you with the memory usage, but I have never used these things myself. AFAIK, the operating system takes care of the CPU time. The only thing you can change is the application's base priority.
> > --
> > Eric den Doop
> > www.foxite.com - The Home Of The Visual FoxPro Experts

>
> Thanks, Eric
> Whenever I do some queries or access the table (it's huge), VFP uses all the resources to do that. I'll try to add some optimizations to my code to speed up the app and look at the SYS() functions. Is it possible to specify the app's priority inside VFP? Thanks


Take a look at SYS(3054) to see if you can optimize your SQL and indexes. Also lookup Rushmore in VFP help. With the proper index tags, even large tables can be queried relatively fast.

There's an API to set the priority. Here's a sample: http://support.microsoft.com/default.aspx?scid=kb;en-us;193846. Remember that this does not fix a performance problem in your application. It only instructs Windows to give some more CPU time to your app!
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts

ENTIRE THREAD

CPU and memory usage Posted by cubi tran @ 10/11/2005 5:11:49 PM
RE: CPU and memory usage Posted by Eric den Doop @ 10/11/2005 5:15:52 PM
RE: CPU and memory usage Posted by cubi tran @ 10/11/2005 5:34:10 PM
RE: CPU and memory usage Posted by Eric den Doop @ 10/11/2005 5:39:34 PM
RE: CPU and memory usage Posted by cubi tran @ 10/11/2005 5:50:30 PM
RE: CPU and memory usage Posted by Simon Arnold @ 10/11/2005 6:24:04 PM
RE: CPU and memory usage Posted by Ken Murphy @ 10/11/2005 6:01:16 PM