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

[Alex Eftimiades]

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:

username: demo
password: demo

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  
read permissions.

	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  
or two.

Thanks for all your help,
Alex


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.
>
> Gilles.
>
> 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  
>>> 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
>>>
>>>
>>
>> _______________________________________________
>> pmwiki-users mailing list
>> pmwiki-users at pmichaud.com
>> http://www.pmichaud.com/mailman/listinfo/pmwiki-users
>>
>
>
>
> -- 
>
> ---------------------------------------
> | A | de la langue française
> | B | http://www.languefrancaise.net/
> | C | languefrancaise at gmail.com
> ---------------------------------------

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pmichaud.com/pipermail/pmwiki-users/attachments/20120812/8ca99bdb/attachment.html>