The recent discussion on Interbase has shaken my faith in a little. I was suggesting
Interbase for a database which while simple in structure will contain a table with
many million records. Now there is only one way that data gets into the database
-bulk loads of data of around 100,000 to 500,000 records at time. Will I need to
backup and restore everytime that is done to get performance out of the
indexes? The database has requirement for minimal management as in a remote
site so very loath to stick with Oracle but at least can re-tune Oracle statistics
easily. Would MSDE be better (my painful memories of Sybase would suggest
not unless some of SYbase's ghosts have well and truly been exorcised in the
MS re-write).
----------------------------------------------------------
Phil Scadden, Institute of Geological and Nuclear Sciences
PO Box 30368, Lower Hutt, New Zealand
Ph +64 4 5704821, fax +64 4 5704603
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz