Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ilya Rabyy
  Where is Ilya Rabyy?
 Fountain Valley
 California - United States
 Ilya Rabyy
 To: Anup Singh
  Where is Anup Singh?
 Delhi
 India
 Anup Singh
 Tags
Subject: RE: SET AUTOSAVE
Thread ID: 209124 Message ID: 209570 # Views: 5 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Windows Vista and VFP
Date: Monday, December 29, 2008 4:57:38 PM         
   


> >
> > Hi Anup,
> >
> > Disk I/O are slowest processes in the computer system because it involves mechanical devices (disk drives). Those two commands you mentioned do exactly that: they transfer the contents of the memory buffers to a disk device.
> >
> > When AUTOSAVE is set ON - it "flushes" buffers to a disk after every read, hence the slowdown in performace speed.
> >
> > OTOH, if you have your stations and/or servers in the area prone to power outages, setting AUTOSAVE ON is not that bad idea if you do not want to lose the data.
> >
> > That's what it is just in general.
> >
> > I, personally, prefer to have AUTOSAVE being OFF, but I FLUSH FORCE the data programmatically every so often when it deems appropriate (say - SCATTER/INSERT in a long SCAN...ENDSCAN cycle).
> >
> > HTH.
> >
> > Regards,
> >
> > Ilya
>
> Thanks for your suggestion
>
> but when we use Flush billing speed get slow if in multi user software.
>
> I was using Flush,Rlock() & Set autosave on. My software speed was slow but when it delete all these commands from my software software speed increase upto 5 times in same network.
>
> What's your suggestion i use it or not. Is it effect on database corruption. What happen when computer shut down with power fluctuation is it only effect on current data or corrupt the table.
>
> With regard
> Anup Singh
> (M.D.)
> MARG Compusoft Pvt. Ltd.
>
> Email:anupmarg@gmail.com
> Web:www.margcompusoft.com

Yes, Anup, server box's shutdown due to power fluctuation may corrupt the data tables on the server. I saw it happen. Are UPS boxes (Uninterruptible Power Supply) available in your area? We practically eliminated data corruption on the servers' disks after we installed these UPS (30 min. capacity) for each server box.

Regards,

Ilya

ENTIRE THREAD

SET AUTOSAVE Posted by Anup Singh @ 12/24/2008 12:31:53 PM
RE: SET AUTOSAVE Posted by Ilya Rabyy @ 12/24/2008 4:40:54 PM
RE: SET AUTOSAVE Posted by Anup Singh @ 12/25/2008 8:11:29 AM
RE: SET AUTOSAVE Posted by Anil Sharma @ 12/25/2008 8:48:32 AM
RE: SET AUTOSAVE Posted by Anup Singh @ 12/30/2008 8:22:17 AM
RE: SET AUTOSAVE Posted by Anil Sharma @ 12/30/2008 8:43:00 AM
RE: SET AUTOSAVE Posted by Anup Singh @ 12/30/2008 8:55:03 AM
RE: SET AUTOSAVE Posted by Anil Sharma @ 12/30/2008 9:32:59 AM
RE: SET AUTOSAVE Posted by Ilya Rabyy @ 12/29/2008 4:57:38 PM