I need to build an interface with 100 Editable Columns and all the columns need to be searchable & editable.(Like a table with 100 columns and we should be able to input something and search / modify the data and submit to DB).Which approach is suitable for this requirement? Should i go with Record Type / Editable Grid.(I am aware that the performance may be slow due to 100 columns. But business want to evaluate how it looks like and see the performance)
Discussion posts and replies are publicly visible
I would strongly recommend you re-think this user experience. It sounds like you're wanting to replicate the UX of an Excel spreadsheet. But this is only ONE solution option to the real requirements you have. I would encourage you to derive the real requirements (WHAT is required, not HOW) and then device what solution options you have to meet those requirements. For example: a wizard (a series of user interfaces that logically lead you through a data-capture process) may be a better experience.