Old JSP-wiki pages in different table

Konstantin Chekushin <[email protected]> Thu, 15 Nov 2007 11:52:54 +0200 (GMT+02:00)
Newsgroups gmane.comp.java.jspwiki.user
Message-ID <[email protected]>
This list is deprecated.  Please subscribe to the 
Apache Incubator jspwiki-user list by sending 
an email to [email protected]
Good day! I am using jspwiki 2.4 and save all attachments and pages in mysql.
At this moment I have 2 tables - "WIKI_ATT" and "WIKI_PAGE".
WIKI_PAGE saves all versions in one table, so at this moment, if I'll look throw the table, I'll see:
mysql> select count(*) from WIKI_PAGE;
+----------+
| count(*) |
+----------+
| 3524 |
+----------+

mysql> select count(distinct NAME) from WIKI_PAGE;
+----------------------+
| count(distinct NAME) |
+----------------------+
| 756 |
+----------------------+

To speedup search procedure I wont to create a dedicated table for previous document versions. (Earlier versions jspwiki, as I remember, had 2 tables for pages storing.) Does exist some patches to make this possible?


-------------------------------------------------------------------------------
http://www.one.lv - Tavs mobilais e-pasts!

Tagad lasi savu e-pastu ar mobilo telefonu - wap.one.lv!