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!!<div>
<br></div><div>Wahoo!</div><div><br></div><div>Should be able to finish these up this weekend for the most part<br><br><div class="gmail_quote">On Thu, Dec 17, 2009 at 2:23 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="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">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! :)<div>
<div></div><div class="h5"><br>
<br><div class="gmail_quote">On Thu, Dec 17, 2009 at 2:20 PM, 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="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>On 12/17/2009 01:04:57 PM, Lacey Maryott Roerish wrote:<br>
> Using the 1 year deletions, leaving the first of the year in to stop<br>
> interpolation, I am able to delete a year in about a minute. This is<br>
> so<br>
> fantastic!<br>
<br>
</div>Well, fantastic in the sense of "not totally lame". :-)<br>
<br>
It's good to know we've a work-around. I didn't want<br>
to spend the time optimizing the interpolation code<br>
for this relatively uncommon use-case.<br>
<br>
I'll add a note to the docs regards this technique.<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>
</div>