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!<div><br></div><div>L<br><br><div class="gmail_quote">On Thu, Dec 17, 2009 at 11:47 AM, Karl O. Pinc <span dir="ltr"><<a href="mailto:kop@meme.com">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 class="im">On 12/17/2009 10:36:05 AM, Lacey Maryott Roerish wrote:<br>
> Hmm I think something may have gotten broken with the query that I<br>
> tried to<br>
> delete 7 years with. I am now trying to run just 2 years, and it has<br>
> taken<br>
> hours. :(<br>
><br>
> On Thu, Dec 17, 2009 at 9:20 AM, Lacey Maryott Roerish<br>
> <<a href="mailto:lroerish4@gmail.com">lroerish4@gmail.com</a>>wrote:<br>
><br>
> > Just to update. This program seems to work pretty well<br>
> > 6 months took 1.27 min<br>
> > 1 yr took 5.17 min (used to be an hour +)<br>
> > 2 years took 25.37 min<br>
> > I tried 7 years (feeling frisky) and it ran all not and<br>
> accomplished<br>
> > nothing.<br>
> ><br>
> > So, it seems as though there is a HUGE amount of gain when deleting<br>
> 1-2<br>
> > years, but pushing it too far seems to cross some barrier where it<br>
> can't<br>
> > figure out what to do at all.<br>
> ><br>
<br>
</div>I think it takes longer as you delete more contiguous rows.<br>
<br>
Try this:<br>
<br>
Delete one year at a time leaving Jan 1 undeleted. Then<br>
after finishing go back and delete all the Jan 1sts.<br>
<br>
See if the 1 year deletions take a constant amount of time<br>
as you progress. If not get back to me and we'll come up<br>
with something.<br>
<div><div></div><div class="h5"><br>
<br>
Karl <<a href="mailto:kop@meme.com">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">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>-- <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>