Karl,<br><br> I finished uploads yesterday. It definitely does seem as though the longer upload times were correlated to when Niki was pulling out the data I was putting in. I think it was just psionload and ranker trying to access the same tables that made it slow. It seemed to speed back up after our conference call during the time when Niki was waiting for me to upload some more data.<br>
<br>L<br><br><br><br><div class="gmail_quote">On Wed, Nov 4, 2009 at 3:33 PM, Karl O. Pinc <span dir="ltr"><<a href="mailto:kop@meme.com">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;">
Lacey,<br>
<br>
If you want to work on performance of your psion uploads<br>
let me know. Are they still slow? The best way to figure<br>
out what's slow is with real data in the real database<br>
so this may be our window of opportunity.<br>
<br>
I've not spent any time looking at the performance<br>
of the uploads done by the data managers. I did<br>
tune the database so that the conversion would run<br>
in a reasonable amount of time, which surely<br>
contributes to an overall improvement in performance,<br>
but there is likely room for improvement.<br>
<br>
All,<br>
<br>
I spoke with Ryan and he says we should be able to get<br>
all of papio restored as-is with the backup we have.<br>
<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>
</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>