[
http://issues.apache.org/jira/browse/JUDDI-89?page=comments#action_12420884 ]
Rémi Flament commented on JUDDI-89:
-----------------------------------
Another bug corrected :
--- C:\salto\FindServiceByNameQuery.java Thu Jul 13 17:26:14 2006
+++ C:\salto\FindServiceByNameQuery2.java Thu Jul 13 17:26:25 2006
@@ -173,7 +173,7 @@
if (keysIn == null)
return;
- sql.append("AND ( S.SERVICE_KEY IN (");
+ sql.append("AND S.SERVICE_KEY IN (");
int keyCount = keysIn.size();
int count = 0;
@@ -193,7 +193,7 @@
}
}
- sql.append(")) ");
+ sql.append(") ");
}
/**
> JDBC Datastore performance improvements
> ---------------------------------------
>
> Key: JUDDI-89
> URL: http://issues.apache.org/jira/browse/JUDDI-89
> Project: jUDDI
> Type: Improvement
> Versions: 0.9rc4
> Environment: Oracle
> Reporter: Rémi Flament
> Assignee: Steve Viens
> Attachments: juddi.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.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
