[Babase] New delete_census function

Susan Alberts alberts at duke.edu
Fri Dec 18 16:24:27 EST 2009


Wow, that's an impressive gain in time. Thanks for the update.
S

On Dec 18, 2009, at 3:57 PM, Lacey Maryott Roerish wrote:

> I just decided to try to do one male all at once but entering all of  
> the queries together (after trying 5-6 queries together, having to  
> do 2-3 chunks per male) and was able to delete all of one males  
> records in 13 minutes!!
>
> Wahoo!
>
> Should be able to finish these up this weekend for the most part
>
> On Thu, Dec 17, 2009 at 2:23 PM, Lacey Maryott Roerish <lroerish4 at gmail.com 
> > wrote:
> fantastic.  yes susan and I Spoke a bit about trying to figure out  
> how much time we should spend optimizing the code versus how long it  
> would take without it... and we figured out that on my current time  
> scale it would have taken a total of 4 months to do them all,  
> whereas a couple of days spend optimizing could mean this only takes  
> another week total.    Looks like that might have been true! :)
>
>
> On Thu, Dec 17, 2009 at 2:20 PM, Karl O. Pinc <kop at meme.com> wrote:
> On 12/17/2009 01:04:57 PM, Lacey Maryott Roerish wrote:
> > 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!
>
> Well, fantastic in the sense of "not totally lame".  :-)
>
> It's good to know we've a work-around.  I didn't want
> to spend the time optimizing the interpolation code
> for this relatively uncommon use-case.
>
> I'll add a note to the docs regards this technique.
>
>
> 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
>
>
>
> -- 
> - -
> Lacey K. Maryott Roerish
> Alberts Lab
> Department of Biology
> Duke University
> ph: 919-660-7306
> fax: 919-660-7293
> Lacey.Maryott at duke.edu
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase

------------------------------------------------------------
Susan Alberts, Dept of Biology, Duke University, Box 90338, Durham NC  
27708. Phone 919-660-7272, FAX 919-660-7293





More information about the Babase mailing list