NYCPHP Meetup

[Adam Fields]

On Wed, Oct 16, 2002 at 10:09:36PM -0400, Jim Hendricks wrote:
> >
> >
> >You can do this without the tierlevel by building dynamic queries of
> >the form:
> >
> Would the resultant SQL perform as well as a straight "SELECT * FROM 
> mytable WHERE tierLevel=4"?

I don't know what kind of query optimization mysql does, but I'd
suspect not. Even still, you have some extra processing in PHP between
the queries.

However, if performance is your goal, I'd say you should be looking at
HTML caching instead, and not generating the page afresh on each view.


-- 
				- Adam

-----
Adam Fields, Managing Partner, fields at surgam.net
Surgam, Inc. is a technology consulting firm with strong background in
delivering scalable and robust enterprise web and IT applications.
http://www.adamfields.com