I am working on this website that catalogues products with their basic information and all. I checked and all the different input features required were possible using a combination of fields(cck) and some related modules, features like multi image upload, multiple field values, dependent fields, node reference. My only fear is this would result in a good number of tables that would effect performance. How serious would that performance hit be is what I am curious about? The website is for a niche segment and wont be expecting thousands of users at the same time, maybe a couple hundred simultaneous users during some promotional event, thats it.

I can code everything from scratch but the last time I tried it in drupal 6, there were a lot many hurdles, specially for ajax based dynamic forms and we are a bit tight on schedule. So i just need some help figuring out if the extra effort would be really worth it.

Thanks.

(ALSO: Why did field/cck have to take a table for each field route instead of a table for a content type? Wouldn't that have been more efficient?)