Well I've never seen it documented but it's something I've always done. I've been
converting clients from an old system to IB5.5. The conversion process inserts
anywhere from 100,000 to 1,000,000 records depending of the client. As it's a
conversion from scratch I don't run the DDL to create indexes and FK's until after the
inserts (so the inserts are faster) so they should all be balanced at this stage but
the performance is still bad on some queries until a backup/restore is done. It must
be related to the PK's as suggested by the original select count(id) problem posted
yesterday.
I have a simply util to do a backup/restore that my clients can run. Over time it
seems that this needs to be done to keep things running fast. I have some
queries/reports that slow from 5 secs to over 1 minute after a about a month of
general use of my app. The bup/rest fixes it.
My faith has been shaken too since running an upgrade at a site the other with a large
DB. I ran a util that simply added a new record into an empty table for every patient
in another table. At this site (but not any others) it would get a "General SQL Error:
Connection lost to database" and random places during the inserts and the DB would
then be corrupted. I tried three times with the same result. It only worked after I
ran my bup/rest util first (which they hadn't run for a month or so). I've been
plagued with this error and corruption at various sites over the last year. It seems
less of a problem now that my clients do regular bup/restores. I certainly have some
stability concerns with IB on win95 (not surprisingly).
regards
Andrew
-----Original Message-----
From: Phil Scadden [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, April 20, 2000 8:59 AM
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
application/ms-tnef
