[thelist] ASP/SQL Question
rudy
r937 at interlog.com
Wed Sep 12 16:07:27 CDT 2001
> Each Product Type requires a seperate query
aaargh
please, above all, your first consideration in any
web database application is to reduce the number
of times the web server calls the database server
the optimum number would be one
> Secondly, would there be some strange, obscure,
> or just overlooked (on my part) SQL trick which
> would reduce the queries needed?
just do a simple join query from products to categories
(write back if you need help)
as for processing the output, this is a very simple matter
if you have any programming experience
at its simplest, you need to make just one pass of the
returned records in the result set, check the current
record against the previous, and do end-of-group
and initialize-group processing conditionally
if you want to use data shaping, be my guest
rudy
More information about the thelist
mailing list