I would say, there shouldn't be a performance gain with going with one huge table. There is a 4gb limit on the size of a table however.
Hope that helps
Is there a major decrease in performance on the server if there are thousands of tables with a small number of records?
What is the really the max number of tables i should have in a database?
I am interested in the performance, but is using to tables to automate a process not displaying a web page using php and mysql.
Cheers
Andrew
[deleted by moderator]
Last edited by alvo; 22 Jan 2008 at 06:29 PM. Reason: New users aren't allowed signatures.
I would say, there shouldn't be a performance gain with going with one huge table. There is a 4gb limit on the size of a table however.
Hope that helps