[pmwiki-users] SQLite pagelist recipe prerelease

[Alex Eftimiades]

I have been trying to redesign some of the common pagelist  
functionality to take advantage of an sqlite installation. You just  
include it after you set your WikiDir to the custom SQLite pagestore  
class. Like the person who sent out the updated pmwiki skin, I was  
looking for some feedback/comments on the implementation and whether  
you think this might help speed up pagelists on an sqlite installation  
with a lot of pages.

This actually has not helped speed up my own pagelists as much as I  
thought it would. In fact, I do not really notice a difference at all!  
Then again, I only have about 550 pages on my site. Perhaps I would  
notice more of a difference if I had several hundred thousand. All the  
more reason I wanted some feedback on the implementation. Right now,  
it takes care of the name=, group=, link=, and order= statements using  
SQLite queries. I hope to extend it to do the page (text) variable  
specifications and if statements as well.

It uses a few custom functions to do FmtPageName for less standard  
order=$Name type declarations and to check if the link= is in the  
targets of the current page it is looking at. I would assume that  
would make the sqlite query closer to just using php, but I thought it  
would make a difference doing the testing on each page as they are  
read from the database rather than reading them all from the database  
into memory and sifting through the results from there. I could be  
wrong, and this might not help at all, or perhaps only help in certain  
situations.

Let me know if you have any insight on this.

Thanks,
Alex
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sqlist.php
Type: text/php
Size: 5821 bytes
Desc: not available
URL: <http://www.pmichaud.com/pipermail/pmwiki-users/attachments/20120826/939ef71d/attachment.bin>
-------------- next part --------------