Interesting side note, Phil: as far as I can remember (which shows how much
an MCP means) Microsoft recommends switching off indexes when you do a bulk
insert, and switching them on again after. You can do the same with
interbase, but a backup and restore is a) quicker and b) forces garbage
collection and other usefull things at the same time.
FWIW.
N
--
Nic Wise - 021.676.418 / [EMAIL PROTECTED] / Inprise/Borland New Zealand
Is it not a foolish man, said little Woo, who keeps all his chickens in his
trousers?
For at best, will he not suffocate his chickens, and, and worst, will he not
disappoint the ladies in the village? --Alexi Sayle
> -----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
