How many rows is too many rows

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
GeXus
Forum Regular
Posts: 631
Joined: Sat Mar 11, 2006 8:59 am

How many rows is too many rows

Post by GeXus »

Say I have a bunch of data that is only a one to one relationship.. and will never change. Would it make sense to store all of that in one table? Such as a users table... it could potentially have 50+ columns.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

If all the columns will be accessed frequently, then keeping them together could be considered a good idea. But if not, then there is a potential to break the table apart a bit. Are there large columns such as TEXT or BLOB? Then there may be potential of breaking those out as well, depending on their use and such.
GeXus
Forum Regular
Posts: 631
Joined: Sat Mar 11, 2006 8:59 am

Post by GeXus »

Alot of the columns will be varchar and text... and they will be accessed frequently... The problem is just having a logical way to break them up.. since they really all pertain to the same thing.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

If you care to explain them all, we may be able to come up with common themes to break them apart into.
GeXus
Forum Regular
Posts: 631
Joined: Sat Mar 11, 2006 8:59 am

Post by GeXus »

Thanks, I think i've actually got it.. basically the information will all be collected from 3 seperate pages, each page is sort of like a subject.. so that works perfect to break them up that way...
Post Reply