Subject RE: [ib-support] Re: Stored procedure problem
Author Alan McDonald
if you want a fast delete, drop the table (you almost hear it :-) then
recreate and insert again

-----Original Message-----
From: Don Gollahon [mailto:gollahon@...]
Sent: Tuesday, 18 March 2003 8:22 AM
To: Ib-Support
Subject: Re: [ib-support] Re: Stored procedure problem

"Aage Johansen" <aagjohan@...> wrote in message
> On Mon, 17 Mar 2003 12:48:10 +0000 (UTC), Don Gollahon
> 1. I find that ("corrupt too easily") hard to believe - could there be
> external problem?

We are currently reinvestigating this problem. It is happening mainly with
our largest database right now.

> 2. Since you do mostly batch processing, it should be possible to find a
> period of low activity where a manual sweep could be run.

We have some 30 companies that we process for, each having their own
database. These are spread over 3 servers. Having 10 companies per server
and many files to import and process for each keeps them all running almost
constantly. We have a maintenance program that we run monthly that extracts
all records to a text file. Then we delete and rebuild the database and run
maintenance to re-import the latest 2 months of data. We were doing deletes
but found out that FB hates to do massive deletes like that (database
problems increased to a high percentage). So thats why we went to the
process I just described.

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to