[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