Re: PHP/MySQL - Splitting similar data to two tables and querying as a whole
Posted by Mike Willbanks on 05/17/05 19:50
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.