I completely agree. Storing file uploads in BLOB fields usually is not very
easy to do and as mentioned, every time a user wants an object you have to
pull the whole object out of the database. This does not scale well at all.
The best solution is to have the database store the path, or enough
information that you can assemble a path, to the object on your web server
or on a caching server somewhere, perhaps Akamai or Digital Island.
--Doug
-----Original Message-----
From: Al Musella, DPM [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 03, 2000 9:18 AM
To: [EMAIL PROTECTED]
Subject: Re: (OT) SQL Server?
You would probably have an easier time with storing the .dat or .mpeg files
in a directory on the webserver and just storing the url to them in the
database. This way when you go to use it, cold fusion and the sql server
aren't tied up with a 100megs of file througput each time someone wants to
watch a video. That would probably bring even the fastest sql / web server
to it's knees!
Al Musella
a1webs.com
At 07:44 PM 9/3/2000 +0800, you wrote:
>hi all,
>
>how do we store .mpeg or .dat to be exact movies in SQL server?? wat would
>be the data type for it??
>
>any ideas?
>
>thanx in advance
>
>akbar
>---------------------------------------------------------------------------
---
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
