Re: Old JSP-wiki pages in different table

This list is deprecated.  Please subscribe to the 
Apache Incubator jspwiki-user list by sending 
an email to [email protected]
Hi Konstantin,

Oh, I almost forgot... The mysql table change won't necessarily speed up 
your searches - JSPWiki uses Lucene from Apache as its search engine by 
default, and Lucene maintains its own indexes!

:O) Mikkel

Konstantin Chekushin wrote:
> 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!
> _______________________________________________
> This is the Jspwiki-users mailing list, in which we discuss the 
> stable release (even-numbered, 2.4.x, 2.6.x), and user-issues. 
> For development discussion, please join jspwiki-dev.
> http://ecyrd.com/cgi-bin/mailman/listinfo/jspwiki-users
> http://www.jspwiki.org/JSPWikiMailingList
>
>
>
>
>
> ----------
> This mail was scanned for viruses at mail.mikkle.dk by ClamAV (tm) and found to be virus free.
>
>   





----------
This mail was scanned for viruses at mail.mikkle.dk by ClamAV (tm) and found to be virus free.