[Babase] New delete_census function
Lacey Maryott Roerish
lroerish4 at gmail.com
Fri Dec 18 15:57:35 EST 2009
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://eeblistserv.Princeton.EDU/pipermail/babase/attachments/20091218/d4a26e23/attachment.html
More information about the Babase
mailing list