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
>
> rmr...@in...
>
>
>
> -------------------------------------------------------
> 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
|
