[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.

Pm



More information about the pmwiki-users mailing list