Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 To: Nadir Khan
  Where is Nadir Khan?
 Karachi
 Pakistan
 Nadir Khan
 Tags
Subject: RE: Table Records
Thread ID: 331067 Message ID: 331099 # Views: 75 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Forms
Date: Monday, December 26, 2011 8:01:10 PM         
   


> Dear Experts
>
> i have 2 problems
>
> (1) my form is opening 15 second
> (2) One recorde Save time 25 seconds
>
> in this form i used 4 tables
> and almost 90,000 records of all tables
>
> how can speed up opening time and save record time
>
>
> thanks
> Nadir


Hi,
The obvious answer is you should not be loading the entire table recordsets, but your forms should be optimized to run a SQL Select to load only the records required. i.e.: In a very large accounting system, I may load in my order / shipment / payment screens only the orders for the past 90 days with an option some where to load records aged over 90 days. Or I could have such code in my forms to load only unpaid records or paid records via menu options. This greatly reduces the load time involved with all forms.
The other option you can play with is to pre-load your forms in your Main.prg startup program with the NoShow option...
DO FORM FormName NOSHOW
Now the initial load time of you exe will increase as each form is preloaded and the tables prior to the application really starting up.

Pete "the IceMan", from the Great White North of Canada.
www.marathongriffincomputers.com

ENTIRE THREAD

Table Records Posted by Nadir Khan @ 12/26/2011 1:11:58 PM
RE: Table Records Posted by Ugur YILMAZ @ 12/26/2011 1:19:59 PM
RE: Table Records Posted by Anil Sharma @ 12/26/2011 1:22:25 PM
RE: Table Records Posted by Pete Sass @ 12/26/2011 8:01:10 PM
RE: Table Records Posted by Zul Rahim @ 12/27/2011 5:17:24 AM
RE: Table Records Posted by Nadir Khan @ 1/2/2012 4:06:36 PM
RE: Table Records Posted by Koen Piller @ 1/2/2012 4:14:07 PM
RE: Table Records Posted by Anders Altberg @ 1/3/2012 12:22:40 PM
RE: Table Records Posted by Nadir Khan @ 1/4/2012 8:55:57 AM
RE: Table Records Posted by Anders Altberg @ 1/6/2012 11:20:47 AM
RE: Table Records Posted by Nadir Khan @ 1/4/2012 3:21:16 PM
RE: Table Records Posted by Pete Sass @ 1/4/2012 3:49:09 PM
RE: Table Records Posted by Nadir Khan @ 1/4/2012 4:18:22 PM
RE: Table Records Posted by Pete Sass @ 1/4/2012 8:13:51 PM
RE: Table Records Posted by Nadir Khan @ 1/14/2012 1:06:54 PM
RE: Table Records Posted by Koen Piller @ 1/7/2012 6:59:58 PM
RE: Table Records Posted by Pete Sass @ 1/8/2012 4:46:45 PM
RE: Table Records Posted by Nadir Khan @ 1/13/2012 6:14:57 PM
RE: Table Records Posted by Nadir Khan @ 1/14/2012 1:07:28 PM
RE: Table Records Posted by Anders Altberg @ 1/15/2012 11:25:11 AM