[Jamwiki-commit] SF.net SVN: jamwiki:[2963] wiki/trunk

[<wr...@us...>]

Revision: 2963
          http://jamwiki.svn.sourceforge.net/jamwiki/?rev=2963&view=rev
Author:   wrh2
Date:     2010-03-21 18:11:47 +0000 (Sun, 21 Mar 2010)

Log Message:
-----------
Performance:
  * Parsing requires numerous lookups to determine if a topic exists, so add
    a DataHandler.lookupTopicId() method that is optimized for this use case.
    Unlike DataHandler.lookupTopic() this method will return only the matching
    topic ID, removing the need for a join with the jam_topic_version table and
    reducing the amount of data that must be returned from the database.
  * The performance improvement from this change is probably about 10% in my
    local benchmarks, but would probably be more for setups where the database
    is not on the same machine as the app server.

Modified Paths:
--------------
    wiki/trunk/jamwiki-core/src/main/java/org/jamwiki/DataHandler.java
    wiki/trunk/jamwiki-core/src/main/java/org/jamwiki/utils/LinkUtil.java
    wiki/trunk/jamwiki-core/src/main/java/org/jamwiki/utils/WikiLink.java
    wiki/trunk/jamwiki-core/src/test/java/org/jamwiki/TestDataHandler.java
    wiki/trunk/jamwiki-war/src/main/resources/sql.ansi.properties
    wiki/trunk/jamwiki-web/src/main/java/org/jamwiki/db/AnsiDataHandler.java
    wiki/trunk/jamwiki-web/src/main/java/org/jamwiki/db/AnsiQueryHandler.java
    wiki/trunk/jamwiki-web/src/main/java/org/jamwiki/db/QueryHandler.java


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.