On May 1, 2008, at 843AM, Richard Heyes wrote:
it's the most flexible and fastest to query.
Mmm, that's debateable. Not knowing the ins and outs of MySQL I'd
hazard a guess that reading an extra 255 bytes from the table file
might be faster in some circumstances than opening two extra table
files. And I don't see why it's more flexible...?
Good point, I should have said "can be more flexible and faster to
query". I've found that every time I try to do something like this
without having a mapping table that I eventually end up wanting to
move to the mapping table setup. Of course that might just be because
I'm so used to doing it that way.
Certainly that doesn't mean that other solutions are wrong or bad in
any way. I need to learn to not speak in absolutes. :)
The latter two solutions I suggested are certainly easier to work
with and (with todays hardware), speed isn't always a factor.
Yes, another great point.
Brady
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
