I have a database of roughly 5000 company records. related to each o
those records are multiple-per-company records of products. for bot
the products and the companies i would like to store reviews an
descriptions. there would be one description per company and produc
but multiple reviews of both. I have the records all stored in Acces
at the moment, but i am hesitant to store the descriptions/reviews i
the same database because of speed and file size. Would i be bette
off storing all the descriptions/reviews in XML and just call them whe
the particular record is retrieved? or would it be fine to just stor
all those in a separate database? maybe just another table will do?
what is the best way to structure this
--
virtuapetePosted from
http://www.pcreview.co.uk/ newsgroup acces