How should I layout this database?
View Single Post
09-10-2008, 07:49 PM
Join Date: Dec 2007
Location: Bucharest, Romania
That's extremely bad for the server that processes the requests. A single MySQL table can work easily with as many as 1 billion rows. And that is alot of info. This way, it only has to deal with one physical file (opening it, reading it, etc.), instead of many table files (equal to the number of tables per user multiplied by the number of users).
I have optimistic thoughts, even though sometimes (if not always) life's a bitch.
The Following User Says Thank You to xenon For This Useful Post:
View Public Profile
Send a private message to xenon
Visit xenon's homepage!
Find More Posts by xenon