[pmwiki-users] Would the sqlite recipe gain anything in storing pages in separate tables based on group?

[Alex Eftimiades]

As I mentioned in previous questions, my wiki does a pagelist (or two)  
every time a page loads. It usually does a search for back links and/ 
or pagetextvariables. My goal was to make the system more scalable at  
such point that I have several thousand, or even a million pages.

So in short, I was under the impression that databases are good for  
searching, and my wiki is structured around a lot of searching.
Alex

On Aug 7, 2012, at 8:17 AM, tamouse mailing lists wrote:

> I am curious: what advantage were you seeking by using a database  
> store for the pages?
>
> On Aug 6, 2012 7:12 PM, "Alex Eftimiades" <alexeftimiades at gmail.com>  
> wrote:
>
>         I just got the sqlite recipe working with all the pages  
> switched over to the database, and after looking at the database  
> structure, I thought it was odd that it did not use separate tables  
> for different groups. I would think this would cut down on the time  
> it takes to access pages, but I could be wrong. I do not know very  
> much about databases in general. I was just wondering whether this  
> was worth working on.
>
> Thanks,
> Alex
>
> _______________________________________________
> pmwiki-users mailing list
> pmwiki-users at pmichaud.com
> http://www.pmichaud.com/mailman/listinfo/pmwiki-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pmichaud.com/pipermail/pmwiki-users/attachments/20120807/7d6376ee/attachment-0001.html>