Re: Performance issues with large binary data in database

2019-09-11 Thread Jérémy DE ROYER via Webobjects-dev
Hi Markus, We do store the files on disk to avoid such issue (;-) When dealing with such problems I do enable debug on adaptor setting -EOAdaptorDebugEnabled to true. You will see clearer what does EOF do. Hope this helps, Jérémy Le 11 sept. 2019 à 11:32, Hugi Thordarson via Webobjects-dev

Re: Performance issues with large binary data in database

2019-09-11 Thread Hugi Thordarson via Webobjects-dev
Hi Markus, when I had problems like this it was usually because I was "accidentally" fetching a lot of the blob-containing objects (like EOF firing a relationship to check delete rules when performing a delete). But I'd start by attaching a profiler like VisualVM to your application to see

Performance issues with large binary data in database

2019-09-11 Thread Markus Ruggiero via Webobjects-dev
A customer of mine has issues with performance. We have identified that ec.saveChanges() sometimes takes ages to finish (tens of seconds, sometimes a minute or more). The application is basically a document hub, nothing too fancy. But the developer (who is not available anymore) once decided to