[Babase] Deleting the "old style" Status codes

Lacey Maryott Roerish lroerish4 at gmail.com
Wed Dec 9 15:37:12 EST 2009


Roger that. I am doing 6 month chunks now, and have consistently been
deleting starting with the latest dates and working back toward their
'birth'

Thanks for explaining this!
Lacey

On Wed, Dec 9, 2009 at 3:35 PM, Karl O. Pinc <kop at meme.com> wrote:

> Lacey,
>
> If you do one year at a time it has to delete
> and add 365 days worth of rows for the first day,
> then another 365 days worth of rows for the second day,
> and so forth for a total of 365 * 365 days.  If you do
> 10 years worth the number is 3650 * 3650, a much larger
> number.
>
> You will also probably find it faster to delete the rows
> if you delete the later rows first, at least if there
> are some "new style" Status codes later in the individual's
> history.
>
>
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://eeblistserv.Princeton.EDU/pipermail/babase/attachments/20091209/a56a20d6/attachment.html


More information about the Babase mailing list