Author: bpapez
Date: Tue May 15 11:38:34 2007
New Revision: 17301
URL: https://svndev.jahia.net/websvn/listing.php?sc=3D1&rev=3D17301&repname=
=3Djahia
Log:
Performance improvement, when reading all field IDs of a page
Modified:
branches/JAHIA-4-1-BRANCH/src/java/org/jahia/services/fields/JahiaField=
UtilsDB.java
Modified: branches/JAHIA-4-1-BRANCH/src/java/org/jahia/services/fields/Jahi=
aFieldUtilsDB.java
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/branches/JAHIA-4-1-BR=
ANCH/src/java/org/jahia/services/fields/JahiaFieldUtilsDB.java&rev=3D17301&=
repname=3Djahia
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
--- branches/JAHIA-4-1-BRANCH/src/java/org/jahia/services/fields/JahiaField=
UtilsDB.java (original)
+++ branches/JAHIA-4-1-BRANCH/src/java/org/jahia/services/fields/JahiaField=
UtilsDB.java Tue May 15 11:38:34 2007
@@ -29,7 +29,9 @@
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.HashMap;
+import java.util.HashSet;
import java.util.Map;
+import java.util.Set;
import java.util.Vector;
=
import org.apache.log4j.Logger;
@@ -732,6 +734,7 @@
PreparedStatement stmt =3D null;
ResultSet rs =3D null;
Vector fieldIDs =3D new Vector ();
+ Set addedFields =3D new HashSet();
try {
dbConn =3D org.jahia.services.database.ConnectionDispenser.get=
Connection ();
if (loadVersion !=3D null) {
@@ -751,8 +754,9 @@
=
while (rs.next ()) {
Integer id =3D new Integer (rs.getInt ("id_jahia_fields_da=
ta"));
- if (!fieldIDs.contains (id)) {
+ if (!addedFields.contains (id)) {
fieldIDs.add (id);
+ addedFields.add (id);
}
}
} catch (SQLException se) {
_______________________________________________
cvs_list mailing list
[email protected]
http://lists.jahia.org/cgi-bin/mailman/listinfo/cvs_list
