[pmwiki-users] Would the sqlite recipe gain anything in storing pages in separate tables based on group?
alexeftimiades at gmail.com
Sun Aug 12 17:06:44 CDT 2012
Yes it is publicly accessible. The wiki is at icare.org/wiki and the
site is at icare.org. You will will get a better feel for the wiki
site if you login with:
Then you will be able to see the researchers and the maps will work.
This is because they are generated by pagelists which in turn read
addresses as page text variables which are only accessible if you have
If you were curious, the site is for a cancer organization called
icare. I am trying to help them get started with a website and a
functional and scalable way of storing their information. They want to
set up and manage a network of doctors and researchers around patients
with various forms of cancer.
Sqlite is very efficient in my case. It sped up the rendering of the
pagelists and maps tremendously. This is because of what is mentioned
earlier about the page text variable searching. It would probably be
worth the effort (for me at least) to modify the sqlite recipe to
store page text variables in the way it stores page variables. That
would speed things up even more for me, but for now, this works fine.
I will also be storing usernames and passwords as page text variables
thanks to a new recipe would like to publish within over the next day
Thanks for all your help,
On Aug 10, 2012, at 4:40 PM, ABClf wrote:
> I'm curious ;)
> Alex, is your pmwiki install public on internet ; can we see ?
> Is sqlite efficient in your case ?
> Thank you.
> 2012/8/8 tamouse mailing lists <tamouse.lists at gmail.com>:
>> 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
>>> every time a page loads. It usually does a search for back links
>>> pagetextvariables. My goal was to make the system more scalable at
>>> 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.
>>> On Aug 7, 2012, at 8:17 AM, tamouse mailing lists wrote:
>>> I am curious: what advantage were you seeking by using a database
>>> for the pages?
>>> On Aug 6, 2012 7:12 PM, "Alex Eftimiades" <alexeftimiades at gmail.com>
>>>> I just got the sqlite recipe working with all the pages
>>>> 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.
>>>> pmwiki-users mailing list
>>>> pmwiki-users at pmichaud.com
>> pmwiki-users mailing list
>> pmwiki-users at pmichaud.com
> | A | de la langue française
> | B | http://www.languefrancaise.net/
> | C | languefrancaise at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pmwiki-users