Decided to test RelStorage, if there is a need to migrate. <div>Converted the database using the configuration:</div><div>"""</div><div><div><filestorage source></div><div> path var/filestorage/Data.fs</div>
<div></filestorage></div><div><br></div><div><relstorage destination></div><div> cache-servers <a href="http://127.0.0.1:11211">127.0.0.1:11211</a></div><div> cache-module-name memcache</div><div> <mysql></div>
<div> db zodb</div><div> user root</div><div> passwd 123</div><div> </mysql></div><div></relstorage></div></div><div>"""</div><div>Convert took around 2 hours and the speed is realy bad. I tried iterating through all objects, by using the findObjectsProviding of zope.app.generations and it took 600 seconds, in contrast to the 20 seconds with FileStorage. </div>
<div>The cache works good though (nearly the same results at single object geting multiple times).</div><div><br></div><div>Maybe mysql set up needs some configuration, that I'm not aware of? Some indexes maybe...</div>