On one of our live sites using SQL server, we do regular (hourly) bulk loads
of data without any problems. There is certainly no need to do index
rebuilds.
Even if you use interbase, surely you do an index rebuild, without having to
backup / restore, can't you?
Regards,
Dennis.
> -----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
