28.04.2014, 20:10
1) I don't believe there's a particular limit. Just what your (physical) server can handle. Let's take these forums for example. Each page request takes approximately 12 queries. There are 900 users online. You do the math.
2) The hard upper limit is 1000 columns (InnoDB). However, I wouldn't use more than 30-ish for one table. Don't make too many columns. Make more tables and more rows instead. Then use joins to assemble the data you want from the different tables.
See my tutorials on database normalization here and here. The second one may be a bit easier to follow because it has images.
2) The hard upper limit is 1000 columns (InnoDB). However, I wouldn't use more than 30-ish for one table. Don't make too many columns. Make more tables and more rows instead. Then use joins to assemble the data you want from the different tables.
See my tutorials on database normalization here and here. The second one may be a bit easier to follow because it has images.