I have been using Interbase in this kind of a capacity for some time. I
spent half of last year doing a stock control system that bulk loaded
transactions from an accounting system and then touched each record to do a
bunch of statistics for forecasting etc.
As part of the proof of concept we thrashed Interbase with multiple 500,000
record transactions, without any special precautions other than sensible
client-server type practices, with no problems.
Personally, I would look at architectural or infrastructure issues. Every
product has ways that it best likes to be treated, often the issue is a gap
between the way we would like it to work and the way it was designed to
work.
Max
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Phil Scadden
Sent: Thursday, 20 April 2000 08:59
To: Multiple recipients of list DELphi
Subject: [DUG]: Interbase suitable when entry is bulk loads??
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
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
