Brian Dailey wrote:
This looks like what I'll ultimately be doing. I played around with
some SQL queries and what I ended up with was similar to this -
joining the table for each data value that I wanted to look up (and
since I expect a matching data value, I don't even have to LEFT JOIN
everything, which speeds it up significantly).
Thanks for all of your help and suggestions!
You may eventually reach a point where your data volume becomes
monstrous and the queries start to take an unacceptably long time to
run, or consume too much CPU, or maybe even lock up the tables from
being written to. At that point (or before) you may want to consider
setting up a second mysql machine as as replicated slave - dedicated for
generating reports. Once you have that you can create triggers or run
periodic batch processes to index your data in more optimized tables so
the reports can be generated on the fly or at least more quickly.
~Rolan
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php