Re: PHP/MySQL - Splitting similar data to two tables and querying as a whole
- From: Mike Willbanks <pencap@xxxxxxxxx>
- Date: Tue, 17 May 2005 11:50:54 -0500
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 .
- References:
- Prev by Date: PHP/MySQL - Splitting similar data to two tables and querying as a whole
- Next by Date: Re: PHP/MySQL - Splitting similar data to two tables and querying as a whole
- Previous by thread: PHP/MySQL - Splitting similar data to two tables and querying as a whole
- Next by thread: Re: PHP/MySQL - Splitting similar data to two tables and querying as a whole
- Index(es):