[pmwiki-users] Would the sqlite recipe gain anything in storing pages in separate tables based on group?
Patrick R. Michaud
pmichaud at pobox.com
Fri Aug 24 02:35:31 CDT 2012
On Thu, Aug 23, 2012 at 12:35:24PM +0200, Peter Bowers wrote:
> [...] Splitting the page-table into multiple
> tables would be non-standard, inefficient, and unnecessarily
> complicated with 0 (probably negative) performance improvement.
FWIW, I agree with Peter here. If the queries are constructed
well (i.e., to use sqlite's filters to reduce the number of page
entries returned to PmWiki), then a single table will be far more
efficient and easier to work with than multiple tables.
More information about the pmwiki-users