Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ron Norman
  Where is Ron Norman?
 San Diego
 California - United States
 Ron Norman
 To: mike castillo
  Where is mike castillo?
 Joo Seng Road, Singapore
 Philippines
 mike castillo
 Tags
Subject: RE: Looking for a Consultant
Thread ID: 155207 Message ID: 155271 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Jobs
Date: Friday, December 28, 2007 7:23:38 PM         
   


> > Looking for a highly experienced VFP person who can figure out why our VFP 5 application (very, very large, written over more than 12 years) experiences inconsistent (hard to duplicate), SIGNIFICANT, slowness when we try running it in VFP 9. We want to migrate to VFP 9 but the slowness is a MAJOR ROAD BLOCK. We understand that the reporting will be slower and that is okay. But screens/forms that open in a few seconds in VFP 5 will take 4 or 5 times that long (inconsistently) in VFP 9. Sometimes these same forms/screens open in roughly the same speed as in VFP 5.
> >
> > We have about 20 desktops with 2GB/memory. We use the dbase tables/database (not SQL server). We know about the SET ENVIRONMENT 70 to keep our SELECT statements consistent with vfp5.
> >
> > Thank you. Please email me if you are interested in taking on this short-term consulting challenge - ronald.norman@sdsu.edu (San Diego, CA, USA).
>
>
> Try to check if you have some VALIDATE DATABASE commands, if so try to ignore and comment those codes and try to re-run again the whole program. Add some indexes so you can make use of the Rushmore Optimization.
>
> Loading problem causes:
> 1. Possibly the form / screen is loading the whole data before it opens, such as:
> * USE Tablename
> The solution for this is just to load the needed data to be used so it will be light weight for the user interface.
> 2. There are several select statements within the form loads and it doesn't use rushmore optimization
> 3. Populating a combobox
> 4. etc... :)
>
> The best thing to do is to understand how the Entry Form / Screen works and it's business logic how it is to be implemented. After doing so, normalize the codes to make it faster, simplier and maintainable.
>
> Hope this helps.

Thank you Mike...all of these tips are very useful should we decide to move to vfp9...it is just disappointing that we would need to do extensive code review/change in order to migrate and keep performance about the same. I understand code changes due to new/changed features in a product and am willing to accept that, but just to keep performance the same...bummer! Regards, Ron

ENTIRE THREAD

Consultant (no more replies needed) Posted by Ron Norman @ 12/27/2007 7:46:05 PM
RE: Looking for a Consultant Posted by Tamar Granor @ 12/27/2007 9:59:05 PM
RE: Looking for a Consultant Posted by Ron Norman @ 12/28/2007 7:25:38 PM
RE: Looking for a Consultant Posted by mike castillo @ 12/28/2007 5:31:08 AM
RE: Looking for a Consultant Posted by Ron Norman @ 12/28/2007 7:23:38 PM
RE: Looking for a Consultant Posted by Mike Yearwood @ 12/30/2007 7:56:41 PM
RE: Looking for a Consultant Posted by Ken Murphy @ 12/28/2007 2:23:55 PM
RE: Looking for a Consultant Posted by Ron Norman @ 12/28/2007 7:06:59 PM
RE: Looking for a Consultant Posted by Ken Murphy @ 12/28/2007 8:43:34 PM