Hi, I'm trying to learn a little about query optimization.. I have a query that is
pretty slow, and was wondering if there is an easy way to speed it up.
mysql EXPLAIN
- SELECT
- mailfrom,
- sum((msgsize)/100) as mb,
- count(id) as count,
- avg(hits) as hits
will be in
all 5 product types.
I am trying to figure out the best way to optimize the relation ship between product
type and product.
if i create a product type table and then list each product in this type, i will have
close to 5 times the number of rows as i do number of products. since almost all
will be in
all 5 product types.
I am trying to figure out the best way to optimize the relation ship between product
type and product.
if i create a product type table and then list each product in this type, i will have
close to 5 times the number of rows as i do number of products. since almost all
^_^
-Original Message-
From: Ken Easson [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 03, 2003 4:55 PM
To: [EMAIL PROTECTED]
Subject: best way to optimize a table with many to few relationship.
hello,
I have a question about database structure and optimization.
I have a shopping cart
out the best way to optimize the relation ship
between product type and product.
if i create a product type table and then list each product in this type, i
will have close to 5 times the number of rows as i do number of products.
since almost all products will be in all product type lists
: Monday, February 03, 2003 10:07 PM
Subject: best way to optimize a table with many to few relationship.
hello,
I have a question about database structure and optimization.
I have a shopping cart where several items can fall into several of many categories,
but each item can also be several