Gossamer Forum
Home : Products : DBMan : Customization :

Need some advice on database

Quote Reply
Need some advice on database
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

Quote Reply
Re: Need some advice on database In reply to
Unless you think the database will exceed 1 meg. you should be fine using just one database.

Unoffical DBMan FAQ
http://webmagic.hypermart.net/dbman/
Quote Reply
Re: Need some advice on database In reply to
Assuming that you do not want to be able to search on information_article, your best bet is to have every record link to a unique external text file. This will keep your DB slim, and also allow the external txt file to be raw HTML if you wish. Use one of JPDeni's many useful mods:

http://www.jpdeni.com/...Mods/externaltxt.txt

Quote Reply
Re: Need some advice on database In reply to
Thanks. I've done the last solution. Works fine for me!!