I am planning some design issues I might face in the future and wanted to know if its possible to create 500+ custom fields. I know I know this seems insane but if its possible to create these many fields it will make my job real easy.
I can recommend to check the following post where this is discussed and explained. Basically the database you have running on the server and the type of fields will impose the limit:
Out of curiosity: What is your use case to have 500+ fields in a single module? Maybe there is another approach for your scenario.
Retrieving data ...