Portal Engine Questions on portal engine and web parts.
Version 7.x > Portal Engine > limit to number of bizform fields? View modes: 
User avatar
Member
Member
matt-awg - 5/16/2013 2:17:42 PM
   
limit to number of bizform fields?
Is there a limit to the number of fields you can add to a form? I could not find one searching devnet and I don't see it mentioned in the documentation, unless I am missing something. I need to add about 120 - 150 fields to a complicated form, will that be a problem? I just want to be sure before I tell the client this is possible and start working only to find out there is a limit!
Thanks,
Matt

User avatar
Kentico Legend
Kentico Legend
Brenden Kehren - 5/16/2013 3:29:19 PM
   
RE:limit to number of bizform fields?
I don't believe the limitation would be with the BizForm or Kentico, I believe the limitation would be a SQL Server limitation. Take a look here at the Maximum Capacity Specs for SQL Server

Some things you might consider:
- the need of all those fields available at one time.
- normalize your table.
- performance When running queries, make sure you only get the columns you need (maybe cache some data)