Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old October 24th, 2004, 08:58 PM
Authorized User
 
Join Date: Aug 2003
Location: Nicholasville, KY, USA.
Posts: 54
Thanks: 0
Thanked 0 Times in 0 Posts
Default Storing Large Amounts Of Data

I want to create a database of articles for my customers to read. The articles include photos and videos.

I am familiar with ASP, JavaScript and MS Access. I have an understanding of XML but have not worked with it.

What is the best way to store articles while still providing the security and organization that a database offers? I have found MS Access to be very limited in the amount of information a particular field can hold. Even using the Memo type, an article seems to be too large. The whole use of the database seems pretty cumbersome for storing large documents.

Judging by the various news sites (MSNBC, CNN, etc.), there must be some efficient way to do this.

Any suggestions are helpful.

Best regards,
sabertec2
Reply With Quote
  #2 (permalink)  
Old October 25th, 2004, 06:22 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 0 Times in 0 Posts
Default

How about using SQL server for storing data? You may think of using TEXT datatype there for storing article content.

I won't suggest you storing images in datbase, you can store the images and video files on the physical drives and use the path for that as URL in database, so that you can put up a link to that which corresponds to the article. On the maintenance part, you should ensure that you delete the files too when an article is removed.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection
Reply With Quote
  #3 (permalink)  
Old October 26th, 2004, 01:25 AM
Authorized User
 
Join Date: Aug 2003
Location: Nicholasville, KY, USA.
Posts: 54
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Vijay G,

I know SQL is the standard for web based database work, but I've never had opportunity to work with it. How much data (bits or characters) does a single SQL text field allow? Some of my articles are actually chapters from some of my service manuals and tend to be pretty long. Needless to say, Access is really limited, but maybe SQL will work.

I agree with you on storing the videos and photos on the drive and simply pointing to them.
Reply With Quote
  #4 (permalink)  
Old October 26th, 2004, 02:12 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Check this link - SQL server - Text and image datatypes

You may break the chapters in to reasonable size and store into multiple records, if that is too large to fit into TEXT datatype columns.

Cheers!
_________________________
- Vijay G
Strive for Perfection
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to read data from large word docs lokanatha reddy ASP.NET 2.0 Professional 0 April 9th, 2007 10:21 AM
How to work through huge amounts of data effective Planet_Jeroen Excel VBA 2 January 16th, 2007 07:12 AM
Not being able to post large chunk of data karjagis Classic ASP XML 1 November 2nd, 2005 08:17 AM
handle large data files in VB andy_routledge Pro VB 6 1 August 6th, 2003 01:08 PM



All times are GMT -4. The time now is 05:04 AM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.