[
https://issues.apache.org/jira/browse/JUDDI-89?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12629039#action_12629039
]
Kurt Stam commented on JUDDI-89:
--------------------------------
Hey Tom,
If you have an example with lots of services then maybe we can check if this
patch helps.
> JDBC Datastore performance improvements
> ---------------------------------------
>
> Key: JUDDI-89
> URL: https://issues.apache.org/jira/browse/JUDDI-89
> Project: jUDDI
> Issue Type: Improvement
> Affects Versions: 0.9rc4
> Environment: Oracle
> Reporter: Rémi Flament
> Assignee: Tom Cunningham
> Fix For: 2.0
>
> Attachments: juddi.patch, juddi3.patch, patch2.patch
>
>
> Hi,
> Please find a *huge* patch attached.
> We have used Juddi with more than an hundred business services and we had
> some issues. This patch correct these issues :
> - Juddi was *very* slow with more than 1000 business services.
> - Oracle cannot handle more than 1000 elements in SQL "IN" request, so Juddi
> crashed when a business entity contained more than 1000 services.
> For the "IN" problem we added a method in util/Config which gives the maximum
> element the db can handle in IN requests.
> For the performance problem we had to rewrite a lot of the JDBC datastore.
> Basically the thing is to avoid to do too much sql requests by grouping them.
> As an example instead of the method fetchService() we use the method
> fetchServices(), etc.
> Thanks to these corrections we had great performance improvement : the
> getbusinessdetail used to take more than 40 seconds on big business entity,
> now it takes about 6 seconds.
> This patch applies to v0.9rc4.
> Regards,
> Rémi Flament.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
