Re: PHP/MySQL - Splitting similar data to two tables and querying as a whole



Larry,

I know I could have mmassive tables and put all of this stuff in there,
but I was thinking I coud improve speed if I were able to just bring in
the archive data only when needed.


SELECT * FROM tbl1, tbl2

obviously * is not great for performance so place the fields there.

Mike
.