Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Anil Sharma
  Where is Anil Sharma?
 ludhiana
 India
 Anil Sharma
 To: Nadir Khan
  Where is Nadir Khan?
 Karachi
 Pakistan
 Nadir Khan
 Tags
Subject: RE: Table Records
Thread ID: 331067 Message ID: 331069 # Views: 86 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Forms
Date: Monday, December 26, 2011 1:22:25 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

in your splash form or when your software is opening just oten your 4 tables once and close them. With this it will comes in windows cache and your form will open fast. and for saving time u need to see the size of table no. of fields the calculation you doing and locking of tables and index and filters buffering lots of things. so show the code here to every one give u more generic advice.


Anil


Accounting Software

Web Development

Accounting, Inventory, Hotel Management, Restaurant Kot Billing, MLM, Excise Accounting and much much more!.
My Blog

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