Is the index and table useage suitable for any sort of partition scheme that
would allow the data to be broken up into multiple tables with the same
structure i.e. data "buckets"?
This would involve quite a bit more admin when adding and retrieving data,
but may delay the onset of the symptoms you are suffering.
Chris O'Brien
-----Original Message-----
From: Phil Scadden [mailto:[EMAIL PROTECTED]]
Sent: Monday, 16 July 2001 4:34
To: Multiple recipients of list delphi
Subject: [DUG]: Single MASSIVE table. Recommendations?
I have application that uses single MASSIVE table (100 million records and
growing). Records get added to it in lots of few hudred thousand to 2-3
million at a
time. Needless to say its a problematic beast. Currently in Oracle which is
struggling
with index re-enabling after bulk load. Interbase as far as I can see hasnt
a bulk
load option at all.
I had wondered about using one of the simpler, single table components out
there to see if they could hack the pace. (eg easytable) Any
recommendations??
----------------------------------------------------------
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/
This e-mail message has been scanned and cleared by MailMarshal
http://www.gen-i.co.nz
This e-mail message has been scanned and cleared by MailMarshal
http://www.gen-i.co.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/
