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!