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

Hello Nadir;

I am using 100+ Tables on my network. And some file sizes are bigger than 400+ mb. On my network and local pc; opening forms under 0,5 seconds and saving data again under 1 seconds.

I do not know any inform about your hardware environment and software. Probably; your network environment is not good (for saving data) . Or your database/index design is not optimised for loading on your forms.

Ugur
Amateur Programmer
VFP 9 SP2, Win7 64 Bit

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