Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » MySQL table count limit and related performance?
MySQL table count limit and related performance? [message #14] Fri, 11 August 2006 18:05 Go to previous message
geofflee is currently offline geofflee
Messages: 1
Registered: August 2006
Location: Berkeley, CA, USA
Junior Member
Hi, I am building a website that will have a large number of users, each with a "personal messageboard" feature. I want to know if it would be more efficient to give each user a dedicated table for storing their own data?

What is the performance impact of having many thousands of tables in MySQL?

Thanks,
Geoffrey Lee
Report message to a moderator
[Message index]

Read Message
Read Message
Previous Topic:Performance problem or reached the limit of MySQL?
Next Topic:Joining many Tables vs. executing many queries
Goto Forum:

  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Mon Jul 6 22:01:38 EDT 2009

Total time taken to generate the page: 0.00937 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.