- Joined
- Jun 18, 2005
- Messages
- 1
- Reaction score
- 0
I have a database of roughly 5000 company records. related to each of those records are multiple-per-company records of products. for both the products and the companies i would like to store reviews and descriptions. there would be one description per company and product but multiple reviews of both. I have the records all stored in Access at the moment, but i am hesitant to store the descriptions/reviews in the same database because of speed and file size. Would i be better off storing all the descriptions/reviews in XML and just call them when the particular record is retrieved? or would it be fine to just store all those in a separate database? maybe just another table will do? what is the best way to structure this?