Re: zodbconvert to Oracle very slow

Sean Upton <[email protected]> Thu, 11 Oct 2018 20:34:22 -0600
Newsgroups gmane.comp.web.zope.zodb
Message-ID <[email protected]>
I cannot tell you what is slowing you down with Oracle+RelStorage target here, I can suggest:

1. Profile the calls within this method as you run zodbconvert:

https://github.com/zodb/relstorage/blob/a821ec1147135752119ce443d22dae0a31d3abd8/relstorage/storage.py#L1503-L1561 <https://github.com/zodb/relstorage/blob/a821ec1147135752119ce443d22dae0a31d3abd8/relstorage/storage.py#L1503-L1561>

2. Optional, but a really good idea to compare against importing into PostgreSQL with a known-good config, for process of elimination (see my previous response to your post on community.plone.org <http://community.plone.org/>).

I hope this is helpful direction.

Sean

> On Oct 11, 2018, at 7:49 AM, Nicolas Göddel <[email protected]> wrote:
> 
> Yes, I always do a zodbpack of the Relstorage with zero days before using zodbconvert. Or do you mean packing Data.fs after converting it from RelStorage?
> 
> Am Donnerstag, 11. Oktober 2018 15:35:48 UTC+2 schrieb Sean Upton:
> Have you tried running convert from a zero-day-packed Data.fs copy?
> 
> 
> 
> -- 
> You received this message because you are subscribed to the Google Groups "zodb" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to [email protected] <mailto:[email protected]>.
> For more options, visit https://groups.google.com/d/optout <https://groups.google.com/d/optout>.

-- 
You received this message because you are subscribed to the Google Groups "zodb" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
For more options, visit https://groups.google.com/d/optout.