Gossamer Forum
Home : Products : DBMan SQL : Discussion :

max number of columns in user db

Quote Reply
max number of columns in user db
Does anybody have any thoughts on the maximum number of columns that can be added to a users database before it gets really unwieldy?

I'm trying to decide whether I can put all of the user information I need (about 35-45 columns total) in the users database, or whether it should be broken up into several different tables. The problem with the multiple tables approach is that I'm having a hell of a time working out a way of getting all of the information added simultaneously and synchronized without resorting to really crude hacks (successive javascript autosubmits with lots of passed hidden fields, for example). It occurs to me that maybe I should just put all of that information into the users database so that it's just a single signup form...

Any thoughts or advice would be enormously appreciated.

Thanks in advance,

Fractured Atlas :: Liberate the Artist
Services: Healthcare, Fiscal Sponsorship, Marketing, Education, The Emerging Artists Fund