Re: zodbconvert to Oracle very slow

Nicolas Göddel <[email protected]> Mon, 17 Sep 2018 03:23:01 -0700 (PDT)

Newsgroups	gmane.comp.web.zope.zodb
Message-ID	<[email protected]>

I can list all of the problematic transactions using this SQL query:

SELECT * FROM
    (
        SELECT TID, COUNT(ZOID) AS cnt FROM OBJECT_STATE GROUP BY TID
    )
ORDER BY cnt DESC

I then get something like this:

TID                 CNT
272491772864331366  22020
272385852108654984  21603
272398516995100808  21301
272577782172764091  20394
272551817462108040  16122
272600915779832320  12449
272577837397018146  11741
...                 ...

The fourth tid for example with 20394 states lasts 20 minutes to process 
with zodbconvert. Together with all the other tids it takes up to two 
hours. That's exaggerating.

-- 
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.