I have run into a
nasty mess.
I need to
consolidate various product catalogs, with multiple fields of information from
each, file attachments, images, etc. from multiple sub-companies into a
single CFMX application. I have designed the Components layer, and the
presentation layer can be developed by any of our developers to suit their
specific needs. The data storage is the real mess. I don't want to
create dozens of tables to store all the relevant data (management nightmare)
and I don't want a few smaller tables with many empty (null) fields (bad
design). XML was a thought, but the number of products is in the tens of
thousands, and looping XML with a file that large is slow.
Any thoughts,
suggestions, lessons learned.
Appreciation in
advance
Matt Knight ►Dresser Corporate Web Team ► Dresser, Inc. ► w: 972 361 9943 ► m: 214 213 4016
