Currently am working on a community based website , In this site i need to built around 40 types of registration forms . To this purpose i had selected drupal core Field API and Entity API. but adding some fields for a single form . i have found that for each field its creating 2 tables named like " field_data_fieldname" & "field_revision_fieldname" . my doubt is that
1) is it affect database performance ? because in my site around 40 forms ? so for each field there are two tables !
2) is there any other options to build these forms ?