Phil
Have you considered bulk loading the new data into a temp table and then
merging it into the main database - overall the load would be slower
(indices being
updated constantly) but the database would be continually available (you
could use
a server side process to merge)
Neven
----- Original Message -----
From: "Phil Scadden" <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
Sent: Monday, 16 July 2001 16:54
Subject: RE: [DUG]: Single MASSIVE table. Recommendations?
> > It's sounds rather specialised - can you do it with disabling the
indexes?
>
> With Sqlldr - I disable (rather than drop) index, load, than reenable.
This is
> much faster than recreating the indices from scratch. (3 hours on fast
unix).
> However, running into an Oracle bug with this at moment.
>
> > Sounds like you really need a different design to beat the problem, it's
> > either that or buy a very fast unix box ...
>
> Pretty hard to see a different design within a relational database.
However we
> are looking at a non-RDBMS solution built for this kind of data.
>
> > What speed trade offs can you accept??
> > eg Slow insert versus fast query.
>
> Already have that! 3 hours for an insert is really below my tolerance
level though.
>
> > So is 2 billion records in a table enough, how often are the bulk
inserts
> > done?
>
> Maybe a couple of times a week on average. 4 in a day followed by maybe a
week
> or two without any.
>
>
>
> ----------------------------------------------------------
> Phil Scadden, Institute of Geological and Nuclear Sciences
> 41 Bell Rd South, 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
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
> Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
