RE: [Phpwebsite-developers] Refactor of Pagemaster Search

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

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

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



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
>


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