Programming Forums - View Single Post

Writlaus · Jul 8th, 2007, 12:23 AM

I have been dealing with mysql for a while now, but I still don't really know how exactly it works, or the most efficient way to do certain things. Is there some web page that explains how it works on a basic level?

One example is that I have one table for the users' accounts, with an id number, username, and password, and then I have other tables called "user_1","user_2", etc. that are created dynamically with the user's id number, when the account is created. These other tables hold more information about that user that seem to be more easily organized in their own tables. Does this impact the efficiency of the system? Will mysql be "bogged down" if it has too many tables?

Jul 8th, 2007, 12:23 AM	#1
Writlaus Hobbyist Programmer Join Date: Nov 2005 Posts: 149 Rep Power: 3	mysql efficiency I have been dealing with mysql for a while now, but I still don't really know how exactly it works, or the most efficient way to do certain things. Is there some web page that explains how it works on a basic level? One example is that I have one table for the users' accounts, with an id number, username, and password, and then I have other tables called "user_1","user_2", etc. that are created dynamically with the user's id number, when the account is created. These other tables hold more information about that user that seem to be more easily organized in their own tables. Does this impact the efficiency of the system? Will mysql be "bogged down" if it has too many tables?