You will get corruption with any database - even Interbase has problems.
However, careful monitoring and a couple of fixing utilities will protect
you. I have one .db file app that's been in use continually for 2 years
with zero corruption. I've had other dbf apps that get corrupted indexes
every 2nd day. There are too many possible factors to protect against
everything.
Foxpro doesn't have much support in the Delphi community so you would be
better to stick with dbf or db. Personally, I prefer dbf because I hate
the Paradox net file scheme but db's do give you better data types and long
field names.
If performance is a issue then for small systems, there's probably not a
lot of difference.
Steve Peacocke <[EMAIL PROTECTED]> on 28/04/99 20:42:01
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list database <[EMAIL PROTECTED]>
cc: (bcc: Peter Jones/Logistics&Information
Technology/Christchurch/Foodstuffs)
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
