[Babase] New delete_census function
Karl O. Pinc
kop at meme.com
Thu Dec 17 11:47:35 EST 2009
On 12/17/2009 10:36:05 AM, Lacey Maryott Roerish wrote:
> Hmm I think something may have gotten broken with the query that I
> tried to
> delete 7 years with. I am now trying to run just 2 years, and it has
> taken
> hours. :(
>
> On Thu, Dec 17, 2009 at 9:20 AM, Lacey Maryott Roerish
> <lroerish4 at gmail.com>wrote:
>
> > Just to update. This program seems to work pretty well
> > 6 months took 1.27 min
> > 1 yr took 5.17 min (used to be an hour +)
> > 2 years took 25.37 min
> > I tried 7 years (feeling frisky) and it ran all not and
> accomplished
> > nothing.
> >
> > So, it seems as though there is a HUGE amount of gain when deleting
> 1-2
> > years, but pushing it too far seems to cross some barrier where it
> can't
> > figure out what to do at all.
> >
I think it takes longer as you delete more contiguous rows.
Try this:
Delete one year at a time leaving Jan 1 undeleted. Then
after finishing go back and delete all the Jan 1sts.
See if the 1 year deletions take a constant amount of time
as you progress. If not get back to me and we'll come up
with something.
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
More information about the Babase
mailing list