Welcome to WebmasterWorld Guest from 184.108.40.206
Forum Moderators: open
It seems like the latter is correct, but unwieldy with a few thousand users inputting values daily.
Maybe I just don't realize how big some mySQL tables get on other sites.
Thanks for any insights.
You may want other miscellaneous fields also (like Comments or Description for the Mileage table), but that's more application-dependent.
If it's a question between stuffing more and more records in a table or more and more data into a field, I'll always vote for records unless you can give me a very compelling argument otherwise. Besides, you're going to hit any upper limit for data in a field long before you reach any similar upper limit for number of records.