I need some advice on structuring a database. In my database (with about a 1,000 items) i have a field called information_article. This field can hold all kinds of information on a article and can be up to 1800 characters or more.
No this is where i need some advice. The information in this field can be very large, let say about one webpage of information. I only will show up this information if the user clicks a link to view this information.
Should i use 2 relational databases? One containing the normal information on the product (which i use to create a pricelist) such as:
- Category
- Article
- Price
And the other one containing the article_information?
Does the article_informationfield in one database effect the speed of retrieving information from the database?
Thanks
No this is where i need some advice. The information in this field can be very large, let say about one webpage of information. I only will show up this information if the user clicks a link to view this information.
Should i use 2 relational databases? One containing the normal information on the product (which i use to create a pricelist) such as:
- Category
- Article
- Price
And the other one containing the article_information?
Does the article_informationfield in one database effect the speed of retrieving information from the database?
Thanks