[Babase] Papio performance

Lacey Roerish lroerish4 at gmail.com
Wed Nov 4 15:37:36 EST 2009


Karl,

  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.

L



On Wed, Nov 4, 2009 at 3:33 PM, Karl O. Pinc <kop at meme.com> wrote:

> Lacey,
>
> If you want to work on performance of your psion uploads
> let me know.  Are they still slow?  The best way to figure
> out what's slow is with real data in the real database
> so this may be our window of opportunity.
>
> I've not spent any time looking at the performance
> of the uploads done by the data managers.  I did
> tune the database so that the conversion would run
> in a reasonable amount of time, which surely
> contributes to an overall improvement in performance,
> but there is likely room for improvement.
>
> All,
>
> I spoke with Ryan and he says we should be able to get
> all of papio restored as-is with the backup we have.
>
>
> 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/20091104/4f20c374/attachment.html


More information about the Babase mailing list