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

tamouse mailing lists tamouse.lists at gmail.com
Wed Aug 8 00:30:22 CDT 2012


Yes, I was wondering about that. Thanks for clarifying.
On Aug 7, 2012 5:30 AM, "Alex Eftimiades" <alexeftimiades at gmail.com> wrote:

> 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<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/4f3b4317/attachment.html>


More information about the pmwiki-users mailing list