[Phpwebsite-developers] Refactor of Pagemaster Search

[Roland, R. M <rmr...@in...>]

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. =20

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.=20

Any recommendations would be appreciated.


Thanks,


Ryan Roland

Application Developer
Information Technology Department
Division of Recreational Sports
Indiana University

rmr...@in...