Hi Steve,
My usage of Paradox has been evolutionary over a number of years. I've found
the following things useful:
1. Set Session.NetDir from within the program (perhaps based upon an INI
file). This avoids problems with people's overall BDE Paradox Net Dir
pointing to different places.
2. Keep an eye on disk space on the network drive. Running out of space (or
quota) is not nice for the databases (you don't use data, but do have to
rebuild indices sometimes).
3. As you suggest, make good use of dbiSaveChanges.
4. Do the standard Delphi method of optimistic writes - avoid locking
records for protracted periods.
5. Keep a good table maintenance utility handy (like the one from
http://www.o2a.com). Even TUtil32.exe from Borland is better than nothing.
I've never lost data, but have had to rebuild indices. Remember that these
tools need exclusive access.
Cheers,
Andrew.
> -----Original Message-----
> From: Steve Peacocke [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, April 28, 1999 7:42 PM
> To: Multiple recipients of list database
> Subject: [DUG-DB]: LAN - Paradox/Foxpro
>
> I'm interested in you opinions/facts regarding an issue I was recently
> made
> aware of. I am currently writing a LAN based program (client server is NOT
> AN OPTION) and have, by default started using Paradox files.
>
> I have been told to look seriously at converting to using FoxPro rather
> than paradox files as these have less corruption. Examples are: missing
> data; continual index corruption; and data corruption.
>
> I have not experienced any of these but have not loaded up the data as
> yet,
> just enough for the light testing involved in the midst of development.
>
> I realise some data corruption in the fault of not using dbiSaveChanges in
> the AfterPost event.
>
> Steve
> __________________________________________________________________
> |Steve Peacocke ([EMAIL PROTECTED])
> | http://trader.co.nz/
> | http://trader.co.nz/vizsla/ http://trader.co.nz/vizsla/docking
> --------------------------------------------------------------------------
> -
> New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
