[Babase] New delete_census function
Lacey Maryott Roerish
lroerish4 at gmail.com
Thu Dec 17 14:04:57 EST 2009
Using the 1 year deletions, leaving the first of the year in to stop
interpolation, I am able to delete a year in about a minute. This is so
fantastic!
L
On Thu, Dec 17, 2009 at 11:47 AM, Karl O. Pinc <kop at meme.com> wrote:
> 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
>
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
>
--
- -
Lacey K. Maryott Roerish
Alberts Lab
Department of Biology
Duke University
ph: 919-660-7306
fax: 919-660-7293
Lacey.Maryott at duke.edu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://eeblistserv.Princeton.EDU/pipermail/babase/attachments/20091217/5d93cfdf/attachment.html
More information about the Babase
mailing list