JBIDE-2173 & JBIDE-2162 - performance improvement (for MySQL?)
by Vitali Yemialyanchyk
Max, hi.
I'd like to discuss JBIDE-2173 & JBIDE-2162.
>From our JBIDE-2162 discussion:
"I try debug DatabaseMetaData code and seems I find the reason. The main
problem here - for each table extracted all foreing keys for all tables:"
This is of course JBIDE-2173 and it seems here are the problems only with
MySQL - I have check Postrgre and got better performance (Postrgre has no
problems with performance).
Also I try to study the problem to find common workaround for it - and seems
it exist!
Now to get foreing keys we are using
getMetaDataDialect().getExportedKeys
but it possible to use
getMetaDataDialect().getImportedKeys
and we will get much better performance - I have check it - it possible and
we will get performance O(n) instead of O(n^2) for MySQL.
Seems this have a sense, isn't it?
About JDBCReader - when I try to modify it I saw some potential problem here
-
This is code to add table into dbs:
Table table = dbs.addTable(quote(getSchemaForModel(schemaName)),
getCatalogForModel(catalogName), quote(tableName));
This is code to get table from dbs:
dbs.getTable(schemaName, catalogName, tableName)
obvious that here will be a problem with quotes.
I think the better way incorporate quotes process into DatabaseCollector.
Best regards,
Vitali
16 years, 3 months
Cyclic dependency
by Marshall Culpepper
Hey guys..
Taking a look at org.jboss.tools.vpe and org.jboss.tools.jsf.vpe.richfaces,
I noticed a cyclic dependency between the two (making the compilation fail).
Obviously trying to remove the dependency from either side gets rid of the
error, but introduces compilation problems since there are imports / code
use from the dependencies.
I was wondering if y'all were aware and had any plans to seperate the code..
the easiest side to fix seems to be org.jboss.tools.vpe, as the only code
dependency is in org.jboss.tools.vpe.editor.util.ElService at line 275:
rst = ComponentUtil.getBundleValue(pageContext, attributeNode);
Any thoughts?
16 years, 3 months
QA Daily report 30 July 2008
by Aliaksey Nis
Hello Denis,
This is Daily QA report for 30 July 2008.
Tasks performed:
1. Functional testing of JBoss Tools 3.0.0 alpha1.
Portlets tests.
2. Visual Page Editor tests.
3. Issues verification.
--
Best regards,
Aliaksey mailto:anis@exadel.com
16 years, 4 months
