[Babase] New delete_census function
Lacey Maryott Roerish
lroerish4 at gmail.com
Thu Dec 17 11:36:05 EST 2009
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.
>
> Being able to delete 2 years at a row, in about 25 minutes, is going to
> speed up this process SO much for me! Yay!
> For now I will just go with that interval!
>
> Thanks again Karl
> Lacey
>
>
> On Wed, Dec 16, 2009 at 4:12 PM, Karl O. Pinc <kop at meme.com> wrote:
>
>> Lacey,
>>
>> I've got a new function for you to quickly delete the old
>> census rows.
>>
>> See: https://papio.biology.duke.edu/babase_system_html/re24.html
>>
>>
>> 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/20091217/5af19e49/attachment.html
More information about the Babase
mailing list