>And if it's actually faster for you to open one table,
>retrieve a record, open another table, retrieve all records >attached to that ID, close the second table, and iterate
No, that's not what I mean at all. I know that's slow. What I do, inevitably, is add the needed field onto every table I want it queried with and make my PHP script update the values in all the tables at once when needed. Basically, I put PHP to work on making the table be such that I only need one query of the one table. That *is* faster. I find with large tables (and I'm working with a message board with aobut 235,000 records in the posts table) that it's the difference between the page loading and not loading. |
