Both would be valid, reasonable options. Some people prefer to store the path to a file in the database. This would allow manipulating the files with any available tools, etc., but it also opens up for failure situations (files moved, deleted, etc.). If you need strict control of the articles, then store them in the database (your app can control what is done to them), otherwise. Choose the approach that best fits your needs.
HTH, Tore. -----Original Message----- From: Imad Jradi [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 04, 2002 8:58 AM To: ActiveServerPages Subject: design issue I have articles that a user writes through a form in an asp and then submits it to the server. What would be the best solution/performance on storing these articles. Do I store them in sql server as text or store them on the hard disk as xml files with references in the database? If anyone can help me with that, I would realy appreciate it. Thanks Imad _________________________________________________________________ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
