I posted a simular message a while ago but some things have changed since then so here goes:<BR><BR>People who register give 4 kinds of data that is asked for in 4 seperate registration pages. In total each record will have approx. 100 fields!!!<BR><BR>Operations that will be performed with the database:<BR>- Checking if UserName exists already during registration<BR>- Registration in 4 steps<BR>- Search for persons on 4 kinds of characteristics<BR>- Update of 4 kinds of data by registered persons<BR><BR>Now again I ask, which is faster and better if I want to maximize performance:<BR>1 big table with 100+ fields OR<BR>4 seperate fields with each approx. 20-30 fields??<BR><BR>Could a possible solution be to keep 4 seperate tables and a joined table withing my database. Then I can use the 4 seperate tables for registration and the huge database for search purposes. If this is possible how do I do this?<BR><BR>Also:<BR>- Please tell me why which is better<BR>- Please tell me what the possible problems could be of such a huge number of fields.