What is the best way to store user-defined fields in the database, provided there might be hundreds of such fields and ten thouthands of records? We have 3 ideas so far:'normilised' approach, i.e. a row per field value, fixed number of user-defined columns (similar to FlexFields in Oracle Apps), or storing all user-defined field values as 1 xml text per key in ntext column.
Which is the best or are there other ways to do it ?
Thank you