You are on the right track. Don't forget to use the EXPLAIN command to
help you tune in your indexes.
One other thing that may help is to try making extracts of some of your
tables as temp tables and using them in the final JOIN query that pulls it
all together. For instance, you could make a t
Hi Shawn,
I think I may have found a solution, but the query takes quite a while
to run...here is what I have now paraphrased:
SELECT
vd.id AS id,
vd.session AS session,
vl.value AS content,
vd2.varvalue AS browser,
vl3.value AS bandwidth
FROM vardata AS vd
LEFT OUTER JOI
Mathew Ray <[EMAIL PROTECTED]> wrote on 03/24/2005 10:42:51 AM:
> Been searching for a while and can't seem to come up with any good
> answers to this - I have a normalized structure of about 5 tables that I
> need to denormalize into one big representation of the entire structure.
> Anyone
Been searching for a while and can't seem to come up with any good
answers to this - I have a normalized structure of about 5 tables that I
need to denormalize into one big representation of the entire structure.
Anyone know of a good tool or resource to 'flatten' my tables easily?
I've got a
