So I am now finding that deleting a year's worth of census rows takes between 9-20 minutes... it seems that I have it figured out, and it doesn't seem to break anything.<br><br>At what point should I feel confident about moving out of test and making these changes in babase? I definitely don't want to run this whole thing on 25 males in test just to turn around and repeat it in babase...<br>
<br>Should I test 1 year prior to entry for every male and just make sure we don't get any weird errors? They are all Matgrp 9... so there is no reason they should be in any data prior to their entry dates...<br><br>Lacey<br>
<br><div class="gmail_quote">On Thu, Nov 19, 2009 at 12:02 PM, Lacey Maryott Roerish <span dir="ltr"><<a href="mailto:lroerish4@gmail.com">lroerish4@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
you must be sending that message because you see what I have been running since 10am... i decided to be a bit bold and tried to delete a bunch of years again, given that i had had such good luck after changing the entry date... anyway, i have other stuff to do so I thought I wqould just let it run.. but am thinking i will abort if it isn't done by lunch :-P<div>
<div></div><div class="h5"><br>
<br><div class="gmail_quote">On Thu, Nov 19, 2009 at 11:39 AM, Karl O. Pinc <span dir="ltr"><<a href="mailto:kop@meme.com" target="_blank">kop@meme.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>On 11/19/2009 10:07:44 AM, Lacey Maryott Roerish wrote:<br>
> On Thu, Nov 19, 2009 at 11:02 AM, Karl O. Pinc <<a href="mailto:kop@meme.com" target="_blank">kop@meme.com</a>> wrote:<br>
><br>
> > On 11/19/2009 09:09:02 AM, Lacey Maryott Roerish wrote:<br>
> > > In test, I just deleted ALY's census row for 07-06-1977 and then<br>
> > > inserted a<br>
> > > new one for C in 2.00 and then deleted the row for 07-05-1977 and<br>
> > > added for<br>
> > > for A for 2.00 and then deleted all of the rows from 01-01-1977<br>
> to<br>
> > > 07-04-1977 and it ran in about three minutes and he is interped<br>
> as<br>
> > > being in<br>
> > > 9.00 from 01-01-1977. yay :-D<br>
<br>
</div>Note that O(n^2) means that if one month takes 3 minutes then<br>
two months will take somewhere around 3 ^ 2 = 9 minutes and<br>
4 months will take somewhere around 9 ^ 2 = 81 minutes and<br>
so forth.<br>
<div><div></div><div><br>
<br>
Karl <<a href="mailto:kop@meme.com" target="_blank">kop@meme.com</a>><br>
Free Software: "You don't pay back, you pay forward."<br>
-- Robert A. Heinlein<br>
<br>
<br>
_______________________________________________<br>
Babase mailing list<br>
<a href="mailto:Babase@www.eco.princeton.edu" target="_blank">Babase@www.eco.princeton.edu</a><br>
<a href="http://www.eco.princeton.edu/mailman/listinfo/babase" target="_blank">http://www.eco.princeton.edu/mailman/listinfo/babase</a><br>
</div></div></blockquote></div><br><br clear="all"><br></div></div><div><div></div><div class="h5">-- <br>- -<br>Lacey K. Maryott Roerish<br>Alberts Lab<br>Department of Biology<br>Duke University<br>ph: 919-660-7306<br>
fax: 919-660-7293<br><a href="mailto:Lacey.Maryott@duke.edu" target="_blank">Lacey.Maryott@duke.edu</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>- -<br>Lacey K. Maryott Roerish<br>Alberts Lab<br>Department of Biology<br>Duke University<br>ph: 919-660-7306<br>fax: 919-660-7293<br><a href="mailto:Lacey.Maryott@duke.edu">Lacey.Maryott@duke.edu</a><br>