RE: [Phpwebsite-developers] Refactor of Pagemaster Search

[<ad...@tu...>]

Ryan,

Sorry for the name confusion earlier.  I'm really bad with names :) 
Anyway, I'm finishing up some updates to pagemaster right now that will
implement a simplified search with only 2 queries.  I added in a page_id
column to the mod_pagemaster_sections table.  I also implemented a method
for adding a URL to uploaded images in sections.  I've written an update
script the can be used by boost to update current v1.32 to the new v1.4. 
I will release all this with a patch release we have planned for today or
tomorrow.

Adam

> Adam,
>
> First off, as much as I respect Richard, I'm not him. :)  But I
> understand, those 'R' names just start to run together.  Secondly, that
> search function I sent you for pagemaster should only use 2 queries.
> However, because I tried to avoid changing anything other than that
> function, I had to do alot of array jumping and searching to determine
> what page a section belonged to.  It's not pretty, but adding that field
> to the sections table would greatly simplify the process.
>
> Actually, I wrote this post to the mailing list a good three weeks ago,
> but it seemed it took awhile to get moderated to the list.  Not sure how
> to get around this though.
>
>
>
> Thanks,
>
>
> Ryan Roland
>
> Application Developer
> Information Technology Department
> Division of Recreational Sports
> Indiana University
>
> rmroland@in...
> Office: 812.855.9617
> Cell: 812.320.0032
>
>
> -----Original Message-----
> From: adam@tu...
> Sent: Wednesday, June 11, 2003 08 31
> To: php...@li...
> Subject: Re: [Phpwebsite-developers] Refactor of Pagemaster Search
>
>
> Richard,
>
> You've got me looking closer at the search function in pagemaster now. :)
> I think I will add a page_id column to the section table so the section
> will know it's parent.  Then it should be possible to pull all search
> results using only 2 queries as opposed to N+1 queries.  I will make sure
> there is an update in the update.php file for pagemaster and release it
> with a patch release we have planned for sometime this week.  I hope this
> will help you out as well as all our users who rely on heavy searching of
> pages.
>
> Adam
>
>> I was looking at the search module, (specifically with regard to the
>> Pagemaster module) and I noticed that the search performed in Pagemaster
>> loops through all pages and sections (with a query PER section).  That
>> means if you have N sections in your entire site, that the search
>> performs
>> exactly N+1 individual queries to the database.
>>
>> I'm working on a possible replacement for the current pagemaster search
>> function, and the only stumbling block is that I get sections, but can't
>> easily determine their parent pages from them.  I'm sure this difficulty
>> is why the current scheme was used, but I'm trying to get to where there
>> are AT MOST N+2 queries issued to the DB (and that's only if every
>> single
>> section has a match to the search criteria).
>>
>> Currently I'm looking at trying to use the 'section_order' field in the
>> pages table to determine if a given section is in a page, so I ask if
>> anyone can tell me now if that is a dead end or not.
>>
>> Any recommendations would be appreciated.
>>
>>
>> Thanks,
>>
>>
>> Ryan Roland
>>
>> Application Developer
>> Information Technology Department
>> Division of Recreational Sports
>> Indiana University
>>
>> rmroland@ind...
>>
>>
>>
>> -------------------------------------------------------
>> This SF.net email is sponsored by:  Etnus, makers of TotalView, The best
>> thread debugger on the planet. Designed with thread debugging features
>> you've never dreamed of, try TotalView 6 free at www.etnus.com.
>> _______________________________________________
>> Phpwebsite-developers mailing list
>> Php...@li...
>> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>>
>
>
> --
> Adam Morton
> Developer - Electronic Student Services
> http://phpwebsite.appstate.edu
> Founder - Appalachian Linux Users Group
> http://alug.appstate.edu
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by:  Etnus, makers of TotalView, The best
> thread debugger on the planet. Designed with thread debugging features
> you've never dreamed of, try TotalView 6 free at www.etnus.com.
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>
>
> -------------------------------------------------------
> This SF.NET email is sponsored by: eBay
> Great deals on office technology -- on eBay now! Click here:
> http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>


-- 
Adam Morton
Developer - Electronic Student Services
http://phpwebsite.appstate.edu
Founder - Appalachian Linux Users Group
http://alug.appstate.edu