Hi everybody!

I'm working on a project that is expecting regularly one or several million records in one of the tables that - unluckily - has got some 70 fields. If you ask me if I don't know anything about normalization, that is not the reason, but it would cost me no little time to build somewhat complex sub-catagory constructions to reduce those (time which I don't have until the deadline for the first release).

Now my question: Who has got experience with this. Is it no problem? (I worked more with VFP databases which therefore are more easy for me to assess than the Sql Server ones). Am I going to run into serious performance issues?

1. How is it to select an average recordset of some hundred (max 2000) records)?
2. How is it to select one only record "WHERE id = value"
3. What is the difference of a SELECT without joins to one with a good number of joins to small key tables?
4. Any tips to do it rather right than false?

Patrick