Images - store in DB or filesystem?
What's the in/out for image storage? Bynary in BLOB database fields or file system or path in text fields? - Original Message - From: Pascal Peters [EMAIL PROTECTED] Date: Fri, 9 Jan 2004 15:40:16 +0100 To: CF-Talk [EMAIL PROTECTED] Subject: RE: insert multiple drop down list selects into access Looks like you want a one-to many relationship. Create a second table for that (with a FK to the existing table). Then loop over the list and insert in the second table within the loop (using the PK from the record in the first table as FK in the second table) -Oorspronkelijk bericht- Van: Tim Laureska [mailto:[EMAIL PROTECTED] Verzonden: vr 9/01/2004 15:15 Aan: CF-Talk CC: Onderwerp: insert multiple drop down list selects into access Is it possible to insert into one access database number field, a comma delimited list of numbers, received from a form template thusly (is not working now ... only can one number to show in the database when multiples are selected on the form drop down): FORM CODE: select name=cat_no multiple cfoutput query=client_catoption value=#cat_no##work_cat#/cfoutput /select TEMPLATE WHERE DATABASE INSERT IS HAPPENING: cfquery datasource=todo dbtype=odbc INSERT into clients (category) VALUES (#cat_no#) /cfquery TIA Tim _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Images - store in DB or filesystem?
Change the datatype from number to text. From: Spectrum WebDesign [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Images - store in DB or filesystem? Date: Fri, 09 Jan 2004 12:15:21 -0300 What's the in/out for image storage? Bynary in BLOB database fields or file system or path in text fields? - Original Message - From: Pascal Peters [EMAIL PROTECTED] Date: Fri, 9 Jan 2004 15:40:16 +0100 To: CF-Talk [EMAIL PROTECTED] Subject: RE: insert multiple drop down list selects into access Looks like you want a one-to many relationship. Create a second table for that (with a FK to the existing table). Then loop over the list and insert in the second table within the loop (using the PK from the record in the first table as FK in the second table) -Oorspronkelijk bericht- Van: Tim Laureska [mailto:[EMAIL PROTECTED] Verzonden: vr 9/01/2004 15:15 Aan: CF-Talk CC: Onderwerp: insert multiple drop down list selects into access Is it possible to insert into one access database number field, a comma delimited list of numbers, received from a form template thusly (is not working now ... only can one number to show in the database when multiples are selected on the form drop down): FORM CODE: select name=cat_no multiple cfoutput query=client_catoption value=#cat_no##work_cat#/cfoutput /select TEMPLATE WHERE DATABASE INSERT IS HAPPENING: cfquery datasource=todo dbtype=odbc INSERT into clients (category) VALUES (#cat_no#) /cfquery TIA Tim _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Images - store in DB or filesystem?
I've always heard path in text fields.From what I understand, storing as BLOBs will bloat the db, and it's rather slow. - Original Message - From: Spectrum WebDesign To: CF-Talk Sent: Friday, January 09, 2004 8:15 AM Subject: Images - store in DB or filesystem? What's the in/out for image storage? Bynary in BLOB database fields or file system or path in text fields? - Original Message - From: Pascal Peters [EMAIL PROTECTED] Date: Fri, 9 Jan 2004 15:40:16 +0100 To: CF-Talk [EMAIL PROTECTED] Subject: RE: insert multiple drop down list selects into access Looks like you want a one-to many relationship. Create a second table for that (with a FK to the existing table). Then loop over the list and insert in the second table within the loop (using the PK from the record in the first table as FK in the second table) -Oorspronkelijk bericht- Van: Tim Laureska [mailto:[EMAIL PROTECTED] Verzonden: vr 9/01/2004 15:15 Aan: CF-Talk CC: Onderwerp: insert multiple drop down list selects into access Is it possible to insert into one access database number field, a comma delimited list of numbers, received from a form template thusly (is not working now ... only can one number to show in the database when multiples are selected on the form drop down): FORM CODE: select name=cat_no multiple cfoutput query=client_catoption value=#cat_no##work_cat#/cfoutput /select TEMPLATE WHERE DATABASE INSERT IS HAPPENING: cfquery datasource=todo dbtype=odbc INSERT into clients (category) VALUES (#cat_no#) /cfquery TIA Tim _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Images - store in DB or filesystem?
I can assure you that storing images in BLOB does not bloat a database. They are designed for this very thing. Though I will admit that Oracle is far better than SQL Server at doing it. I have never really dealt with mySQL and it's been years since I used Informix so I can't tell you much on those products. We do this for our fax apps. We store all types of data in Oracle BLOBS and it is actually faster than file writes. We use a JSP page to do the pulls and puts. In fact we even integrated it into our PeopleSoft product so that our remote locations can now just fax in new hire documents, the faxes go directly to the database and are available for viewing through the Job panel in PS. Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 _ From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 10:42 AM To: CF-Talk Subject: Re: Images - store in DB or filesystem? I've always heard path in text fields.From what I understand, storing as BLOBs will bloat the db, and it's rather slow. - Original Message - From: Spectrum WebDesign To: CF-Talk Sent: Friday, January 09, 2004 8:15 AM Subject: Images - store in DB or filesystem? What's the in/out for image storage? Bynary in BLOB database fields or file system or path in text fields? - Original Message - From: Pascal Peters [EMAIL PROTECTED] Date: Fri, 9 Jan 2004 15:40:16 +0100 To: CF-Talk [EMAIL PROTECTED] Subject: RE: insert multiple drop down list selects into access Looks like you want a one-to many relationship. Create a second table for that (with a FK to the existing table). Then loop over the list and insert in the second table within the loop (using the PK from the record in the first table as FK in the second table) -Oorspronkelijk bericht- Van: Tim Laureska [mailto:[EMAIL PROTECTED] Verzonden: vr 9/01/2004 15:15 Aan: CF-Talk CC: Onderwerp: insert multiple drop down list selects into access Is it possible to insert into one access database number field, a comma delimited list of numbers, received from a form template thusly (is not working now ... only can one number to show in the database when multiples are selected on the form drop down): FORM CODE: select name=cat_no multiple cfoutput query=client_catoption value=#cat_no##work_cat#/cfoutput /select TEMPLATE WHERE DATABASE INSERT IS HAPPENING: cfquery datasource=todo dbtype=odbc INSERT into clients (category) VALUES (#cat_no#) /cfquery TIA Tim _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Images - store in DB or filesystem?
Spectrum WebDesign wrote: What's the in/out for image storage? Bynary in BLOB database fields or file system or path in text fields? Depends on usage pattern. What do you intend to do with your images? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Images - store in DB or filesystem?
I can assure you that storing images in BLOB does not bloat a database. They are designed for this very thing. Though I will admit that Oracle is far better than SQL Server at doing it. I have never really dealt with mySQL and it's been years since I used Informix so I can't tell you much on those products. Bloat may not be the best way to term it. However, storing BLOBs and CLOBs in a relational database leads to spatial issues since the database has to pull data from multiple parts of the disk when returning each row. Generally, the database keeps data in a table all in the same part of a disk such that pulling it is efficient. Thus, as more and more of these objects are added to the database things start to slow down. Depending on the application the slow down may not be even noticed; it all depends. Relational databases were never designed to store these types of objects, they only put them in because that is what customers want and it was a good way to fight back against the OO databases. The truth is that relational databases have become the silver bullet for long term persistence even if they aren't the most appropriate solution. -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Images - store in DB or filesystem?
Web sites but i'm looking for up-to-date technology... If stored images in BLOB fields is very slow why Oracle/SQL Server/Informix/MySQL companies agrees with that technology?? - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] Date: Fri, 09 Jan 2004 16:53:55 +0100 To: CF-Talk [EMAIL PROTECTED] Subject: Re: Images - store in DB or filesystem? Spectrum WebDesign wrote: What's the in/out for image storage? Bynary in BLOB database fields or file system or path in text fields? Depends on usage pattern. What do you intend to do with your images? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Images - store in DB or filesystem?
Hi Steven: I'll have to defer to your experience here, as my answer was based only on a response I got from an instructor when asking him this same question...so I've always done it the text datatype/file path method. Maybe 'bloat' was too strong of a word?Maybe he just meant that storing the images as files would take up -less- space than storing them as BLOBs? Charlie - Original Message - From: Schuster, Steven To: CF-Talk Sent: Friday, January 09, 2004 8:47 AM Subject: RE: Images - store in DB or filesystem? I can assure you that storing images in BLOB does not bloat a database. They are designed for this very thing. Though I will admit that Oracle is far better than SQL Server at doing it. I have never really dealt with mySQL and it's been years since I used Informix so I can't tell you much on those products. We do this for our fax apps. We store all types of data in Oracle BLOBS and it is actually faster than file writes. We use a JSP page to do the pulls and puts. In fact we even integrated it into our PeopleSoft product so that our remote locations can now just fax in new hire documents, the faxes go directly to the database and are available for viewing through the Job panel in PS. Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 _ From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 10:42 AM To: CF-Talk Subject: Re: Images - store in DB or filesystem? I've always heard path in text fields.From what I understand, storing as BLOBs will bloat the db, and it's rather slow. - Original Message - From: Spectrum WebDesign To: CF-Talk Sent: Friday, January 09, 2004 8:15 AM Subject: Images - store in DB or filesystem? What's the in/out for image storage? Bynary in BLOB database fields or file system or path in text fields? - Original Message - From: Pascal Peters [EMAIL PROTECTED] Date: Fri, 9 Jan 2004 15:40:16 +0100 To: CF-Talk [EMAIL PROTECTED] Subject: RE: insert multiple drop down list selects into access Looks like you want a one-to many relationship. Create a second table for that (with a FK to the existing table). Then loop over the list and insert in the second table within the loop (using the PK from the record in the first table as FK in the second table) -Oorspronkelijk bericht- Van: Tim Laureska [mailto:[EMAIL PROTECTED] Verzonden: vr 9/01/2004 15:15 Aan: CF-Talk CC: Onderwerp: insert multiple drop down list selects into access Is it possible to insert into one access database number field, a comma delimited list of numbers, received from a form template thusly (is not working now ... only can one number to show in the database when multiples are selected on the form drop down): FORM CODE: select name=cat_no multiple cfoutput query=client_catoption value=#cat_no##work_cat#/cfoutput /select TEMPLATE WHERE DATABASE INSERT IS HAPPENING: cfquery datasource=todo dbtype=odbc INSERT into clients (category) VALUES (#cat_no#) /cfquery TIA Tim _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Images - store in DB or filesystem?
I can assure you that storing images in BLOB does not bloat a database. They are designed for this very thing. I would agree with you about the choice of the word bloat, but relational databases are hardly designed for storing binary data - it's purely an afterthought at most. Relational databases are very good at storing and retrieving character strings, and SQL is appropriate for searching character strings. Neither is especially adept for working with binary data. In most cases, I've found little or no benefit in storing binary data in a database instead of just storing it on the filesystem, and in some cases, I've found that filesystem storage performs a lot better and is easier to implement. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Images - store in DB or filesystem?
Spectrum WebDesign wrote: Web sites That is not exactly what I would call a usage pattern. What *xactly* do you intent to do with the images? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Images - store in DB or filesystem?
Jochem web page display... img src=""> - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] Date: Fri, 09 Jan 2004 17:19:20 +0100 To: CF-Talk [EMAIL PROTECTED] Subject: Re: Images - store in DB or filesystem? Spectrum WebDesign wrote: Web sites That is not exactly what I would call a usage pattern. What *xactly* do you intent to do with the images? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Images - store in DB or filesystem?
Spectrum WebDesign wrote: web page display... img src=""> How many images? How big are the images? How often will they be displayed? Will they be cached somewhere? How often will there be images inserted/updated? Do you intent to use the images in relational queries? Do you want to search your images? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Images - store in DB or filesystem?
cases, I've found little or no benefit in storing binary data in a database instead of just storing it on the filesystem, and in some cases, I've found that filesystem storage performs a lot better and is easier to implement. well the GIS industry builds uses huge monster thumping databases. the current data (spatial primitives) storage trends there are towards relational databases (you might actually say they are running screaming away from file system storage). in enterprise apps, give me the db method everytime (thanks but i've done my time in file system purgatory). just a for instance: http://www.esri.com/software/arcgis/arcinfo/arcsde/index.html [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Images - store in DB or filesystem?
Hmm, that's odd I thought that was what InterMedia from Oracle was all about? Of course they just scratched the surface in 8i but in 9i it's all about that. I can search binary data, both clob and blob. They can be stored within the database structure itself or in separate files associated with the db structure. They have little or nothing to do at all with relational modeling. We currently have functionality that allows us to store PDF in Oracle and search the BLOB for content. Now, of course, that won't work with images and more proprietary formats that are not conducive to text searching but it works perfect for us. We even ran comparisons against retrieval and write vs. write/read. So long as you stream output using JSPwe find that the DB is faster than the filesystem most always. Granted our Oracle environment runs on Digital UNIX so I haven't tried this on NT running UNIX. Also If you are on SQL server I am sure the differences may be somewhat less desirable as well. But that's just IMHO regardless. Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 _ From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 11:15 AM To: CF-Talk Subject: RE: Images - store in DB or filesystem? I can assure you that storing images in BLOB does not bloat a database. They are designed for this very thing. I would agree with you about the choice of the word bloat, but relational databases are hardly designed for storing binary data - it's purely an afterthought at most. Relational databases are very good at storing and retrieving character strings, and SQL is appropriate for searching character strings. Neither is especially adept for working with binary data. In most cases, I've found little or no benefit in storing binary data in a database instead of just storing it on the filesystem, and in some cases, I've found that filesystem storage performs a lot better and is easier to implement. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Images - store in DB or filesystem?
Well I'm not sure about taking up less size at all. Now given you will have to create an initial database but minus that it's just data. Regardless if you go this route the space differences would be minimal. If you want I can post the JSP code we use for retrieval? Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 _ From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 11:04 AM To: CF-Talk Subject: Re: Images - store in DB or filesystem? Hi Steven: I'll have to defer to your experience here, as my answer was based only on a response I got from an instructor when asking him this same question...so I've always done it the text datatype/file path method. Maybe 'bloat' was too strong of a word?Maybe he just meant that storing the images as files would take up -less- space than storing them as BLOBs? Charlie - Original Message - From: Schuster, Steven To: CF-Talk Sent: Friday, January 09, 2004 8:47 AM Subject: RE: Images - store in DB or filesystem? I can assure you that storing images in BLOB does not bloat a database. They are designed for this very thing. Though I will admit that Oracle is far better than SQL Server at doing it. I have never really dealt with mySQL and it's been years since I used Informix so I can't tell you much on those products. We do this for our fax apps. We store all types of data in Oracle BLOBS and it is actually faster than file writes. We use a JSP page to do the pulls and puts. In fact we even integrated it into our PeopleSoft product so that our remote locations can now just fax in new hire documents, the faxes go directly to the database and are available for viewing through the Job panel in PS. Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 _ From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 10:42 AM To: CF-Talk Subject: Re: Images - store in DB or filesystem? I've always heard path in text fields.From what I understand, storing as BLOBs will bloat the db, and it's rather slow. - Original Message - From: Spectrum WebDesign To: CF-Talk Sent: Friday, January 09, 2004 8:15 AM Subject: Images - store in DB or filesystem? What's the in/out for image storage? Bynary in BLOB database fields or file system or path in text fields? - Original Message - From: Pascal Peters [EMAIL PROTECTED] Date: Fri, 9 Jan 2004 15:40:16 +0100 To: CF-Talk [EMAIL PROTECTED] Subject: RE: insert multiple drop down list selects into access Looks like you want a one-to many relationship. Create a second table for that (with a FK to the existing table). Then loop over the list and insert in the second table within the loop (using the PK from the record in the first table as FK in the second table) -Oorspronkelijk bericht- Van: Tim Laureska [mailto:[EMAIL PROTECTED] Verzonden: vr 9/01/2004 15:15 Aan: CF-Talk CC: Onderwerp: insert multiple drop down list selects into access Is it possible to insert into one access database number field, a comma delimited list of numbers, received from a form template thusly (is not working now ... only can one number to show in the database when multiples are selected on the form drop down): FORM CODE: select name=cat_no multiple cfoutput query=client_catoption value=#cat_no##work_cat#/cfoutput /select TEMPLATE WHERE DATABASE INSERT IS HAPPENING: cfquery datasource=todo dbtype=odbc INSERT into clients (category) VALUES (#cat_no#) /cfquery TIA Tim _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Images - store in DB or filesystem?
PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 _ From: Schuster, Steven [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 12:40 PM To: CF-Talk Subject: RE: Images - store in DB or filesystem? Well I'm not sure about taking up less size at all. Now given you will have to create an initial database but minus that it's just data. Regardless if you go this route the space differences would be minimal. If you want I can post the JSP code we use for retrieval? Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 _ From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 11:04 AM To: CF-Talk Subject: Re: Images - store in DB or filesystem? Hi Steven: I'll have to defer to your experience here, as my answer was based only on a response I got from an instructor when asking him this same question...so I've always done it the text datatype/file path method. Maybe 'bloat' was too strong of a word?Maybe he just meant that storing the images as files would take up -less- space than storing them as BLOBs? Charlie - Original Message - From: Schuster, Steven To: CF-Talk Sent: Friday, January 09, 2004 8:47 AM Subject: RE: Images - store in DB or filesystem? I can assure you that storing images in BLOB does not bloat a database. They are designed for this very thing. Though I will admit that Oracle is far better than SQL Server at doing it. I have never really dealt with mySQL and it's been years since I used Informix so I can't tell you much on those products. We do this for our fax apps. We store all types of data in Oracle BLOBS and it is actually faster than file writes. We use a JSP page to do the pulls and puts. In fact we even integrated it into our PeopleSoft product so that our remote locations can now just fax in new hire documents, the faxes go directly to the database and are available for viewing through the Job panel in PS. Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 _ From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 10:42 AM To: CF-Talk Subject: Re: Images - store in DB or filesystem? I've always heard path in text fields.From what I understand, storing as BLOBs will bloat the db, and it's rather slow. - Original Message - From: Spectrum WebDesign To: CF-Talk Sent: Friday, January 09, 2004 8:15 AM Subject: Images - store in DB or filesystem? What's the in/out for image storage? Bynary in BLOB database fields or file system or path in text fields? - Original Message - From: Pascal Peters [EMAIL PROTECTED] Date: Fri, 9 Jan 2004 15:40:16 +0100 To: CF-Talk [EMAIL PROTECTED] Subject: RE: insert multiple drop down list selects into access Looks like you want a one-to many relationship. Create a second table for that (with a FK to the existing table). Then loop over the list and insert in the second table within the loop (using the PK from the record in the first table as FK in the second table) -Oorspronkelijk bericht- Van: Tim Laureska [mailto:[EMAIL PROTECTED] Verzonden: vr 9/01/2004 15:15 Aan: CF-Talk CC: Onderwerp: insert multiple drop down list selects into access Is it possible to insert into one access database number field, a comma delimited list of numbers, received from a form template thusly (is not working now ... only can one number to show in the database when multiples are selected on the form drop down): FORM CODE: select name=cat_no multiple cfoutput query=client_catoption value=#cat_no##work_cat#/cfoutput /select TEMPLATE WHERE DATABASE INSERT IS HAPPENING: cfquery datasource=todo dbtype=odbc INSERT into clients (category) VALUES (#cat_no#) /cfquery TIA Tim _ _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Images - store in DB or filesystem?
Stephen, I'd be interested in seeing the JSP code, particularly the part about streaming the output. Thanks, Dave Jones NetEffect At 12:39 PM 1/9/04 -0500, you wrote: Well I'm not sure about taking up less size at all. Now given you will have to create an initial database but minus that it's just data. Regardless if you go this route the space differences would be minimal. If you want I can post the JSP code we use for retrieval? Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 _ From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 11:04 AM To: CF-Talk Subject: Re: Images - store in DB or filesystem? Hi Steven: I'll have to defer to your experience here, as my answer was based only on a response I got from an instructor when asking him this same question...so I've always done it the text datatype/file path method. Maybe 'bloat' was too strong of a word?Maybe he just meant that storing the images as files would take up -less- space than storing them as BLOBs? Charlie - Original Message - From: Schuster, Steven To: CF-Talk Sent: Friday, January 09, 2004 8:47 AM Subject: RE: Images - store in DB or filesystem? I can assure you that storing images in BLOB does not bloat a database. They are designed for this very thing. Though I will admit that Oracle is far better than SQL Server at doing it. I have never really dealt with mySQL and it's been years since I used Informix so I can't tell you much on those products. We do this for our fax apps. We store all types of data in Oracle BLOBS and it is actually faster than file writes. We use a JSP page to do the pulls and puts. In fact we even integrated it into our PeopleSoft product so that our remote locations can now just fax in new hire documents, the faxes go directly to the database and are available for viewing through the Job panel in PS. Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 _ From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 10:42 AM To: CF-Talk Subject: Re: Images - store in DB or filesystem? I've always heard path in text fields.From what I understand, storing as BLOBs will bloat the db, and it's rather slow. - Original Message - From: Spectrum WebDesign To: CF-Talk Sent: Friday, January 09, 2004 8:15 AM Subject: Images - store in DB or filesystem? What's the in/out for image storage? Bynary in BLOB database fields or file system or path in text fields? - Original Message - From: Pascal Peters [EMAIL PROTECTED] Date: Fri, 9 Jan 2004 15:40:16 +0100 To: CF-Talk [EMAIL PROTECTED] Subject: RE: insert multiple drop down list selects into access Looks like you want a one-to many relationship. Create a second table for that (with a FK to the existing table). Then loop over the list and insert in the second table within the loop (using the PK from the record in the first table as FK in the second table) -Oorspronkelijk bericht- Van: Tim Laureska [mailto:[EMAIL PROTECTED] Verzonden: vr 9/01/2004 15:15 Aan: CF-Talk CC: Onderwerp: insert multiple drop down list selects into access Is it possible to insert into one access database number field, a comma delimited list of numbers, received from a form template thusly (is not working now ... only can one number to show in the database when multiples are selected on the form drop down): FORM CODE: select name=cat_no multiple cfoutput query=client_catoption value=#cat_no##work_cat#/cfoutput /select TEMPLATE WHERE DATABASE INSERT IS HAPPENING: cfquery datasource=todo dbtype=odbc INSERT into clients (category) VALUES (#cat_no#) /cfquery TIA Tim _ _ _ -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Images - store in DB or filesystem?
Do you have a rough estimate of the performance difference of using this streamed output via JSP compared to just doing a standard CF query? -Kevin - Original Message - From: Schuster, Steven [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, January 09, 2004 11:45 AM Subject: RE: Images - store in DB or filesystem? For Inserts we just use the cf_blob type in MX 6.1 and do a direct insert into the blob. To retrieve we have this JSP page. This allows a direct stream read to the browser and does not write the file to the system and then attempt to read it. But we have code that does that as well if you need to look at it also. This is a JSP page so you must be running MX for this to work (or a JSP alternative) [snip [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Images - store in DB or filesystem?
I did, let me dig around and see if I can find them. I already posted the JSP code, here is the CF equivalent that writes the file to disk and lets you view them. This doesn't take any more space either as the cfcontent tag simply deletes the file after it has streamed to the browser. cfparam name=SID default=None cfparam name=ID default=0 cfparam name=Table default=None cfparam name=Extn default=ext cfparam name=UidField default=ID cfparam name=MediaField default=Media cfparam name=DirectorySet default=c:\inetpub\wwwroot\Faxed\viewacts\ cfif #ID# IS 0 p General Error Occured /p cfabort cfelse cftry CFQUERY name=qryGetCV datasource=#SID# SELECT * FROM #Table# WHERE #uidfield# = #ID# /CFQUERY cfcatch type=Database A general database error has occured trying to run the specified query! p SELECT * FROM #Table# WHERE #uidfield# = #ID# /p cfabort /cfcatch /cftry !--- Create the Temp Files --- cfdirectory directory=#DirectorySet# name=qryFindIt cfset temp = ValueList(qryFindIt.Name) cfoutput query=qryGetCV cfset FileVal = #Evaluate(qryGetCV. #uidfield#)# . #Evaluate(qryGetCV. #Extn#)# cfset myCount = ListValueCount(temp, FileVal) cfif #myCount# IS 1 !--- Skip For Now --- cfelse cffile action=""> file=#DirectorySet##FileVal# output=#toBinary(Evaluate(qryGetCV. #mediafield#))# addnewline=No /cfif /cfoutput cfset Ext =#Evaluate(qryGetCV. #Extn#)# !--- Display File in Browser --- !--- Also deleted the file after it has been written to conserve space --- cfif Ext IS PDF cfcontent file=#DirectorySet##Evaluate(FileVal)# type=application/pdf deletefile cfelseif Ext IS TIFF or Ext IS TIF cfcontent file=#DirectorySet##Evaluate(FileVal)# type=image/tiff deletefile cfelseif Ext IS GIF cfcontent file=#DirectorySet##Evaluate(FileVal)# type=image/gif deletefile cfelseif Ext IS BMP cfcontent file=#DirectorySet##Evaluate(FileVal)# type=image/bmp deletefile cfelseif ucase(Ext) IS MAX cfcontent file=#DirectorySet##Evaluate(FileVal)# type=application/max deletefile cfelseif Ext IS CSV cfcontent file=#DirectorySet##Evaluate(FileVal)# type=application/vnd.ms-excel deletefile cfelseif Ext IS XLS cfcontent file=#DirectorySet##Evaluate(FileVal)# type=application/vnd.ms-excel deletefile cfelseif Ext IS DOC cfcontent file=#DirectorySet##Evaluate(FileVal)# type=application/msword deletefile cfelseif Ext IS MP3 cfcontent file=#DirectorySet##Evaluate(FileVal)# type=audio/x-mpeg3 deletefile cfelseif Ext IS TXT cfcontent file=#DirectorySet##Evaluate(FileVal)# type=text/html deletefile cfelseif Ext IS HTM cfcontent file=#DirectorySet##Evaluate(FileVal)# type=text/html deletefile cfelse cfcontent file=#DirectorySet##Evaluate(FileVal)# type=text/html deletefile /cfif /cfif Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 _ From: Kevin Graeme [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 1:51 PM To: CF-Talk Subject: Re: Images - store in DB or filesystem? Do you have a rough estimate of the performance difference of using this streamed output via JSP compared to just doing a standard CF query? -Kevin - Original Message - From: Schuster, Steven [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, January 09, 2004 11:45 AM Subject: RE: Images - store in DB or filesystem? For Inserts we just use the cf_blob type in MX 6.1 and do a direct insert into the blob. To retrieve we have this JSP page. This allows a direct stream read to the browser and does not write the file to the system and then attempt to read it. But we have code that does that as well if you need to look at it also. This is a JSP page so you must be running MX for this to work (or a JSP alternative) [snip _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Images - store in DB or filesystem?
For CFMX to retrieve you can use CFX_GetImage and to Input in DB CFX_INPUTIMAGE... From Jukka Manner works great... I can send in PVT that zip files (50KB) - Original Message - From: Kevin Graeme [EMAIL PROTECTED] Date: Fri, 9 Jan 2004 12:51:06 -0600 To: CF-Talk [EMAIL PROTECTED] Subject: Re: Images - store in DB or filesystem? Do you have a rough estimate of the performance difference of using this streamed output via JSP compared to just doing a standard CF query? -Kevin - Original Message - From: Schuster, Steven [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, January 09, 2004 11:45 AM Subject: RE: Images - store in DB or filesystem? For Inserts we just use the cf_blob type in MX 6.1 and do a direct insert into the blob. To retrieve we have this JSP page. This allows a direct stream read to the browser and does not write the file to the system and then attempt to read it. But we have code that does that as well if you need to look at it also. This is a JSP page so you must be running MX for this to work (or a JSP alternative) [snip [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Images - store in DB or filesystem?
Hmm, that's odd I thought that was what InterMedia from Oracle was all about? Of course they just scratched the surface in 8i but in 9i it's all about that. I can search binary data, both clob and blob. They can be stored within the database structure itself or in separate files associated with the db structure. They have little or nothing to do at all with relational modeling. InterMedia is just an abstraction. The BLOBs and CLOBs are stored just as they always are, so when you need to search inside them InterMedia retrieves the object, transforms it into what is supposed to be (PDF, XML, etc) and only then is able to look inside it. As far as separate files associated with the DB structure, that isn't an InterMedia feature; that is just a BFile type, which stores a pointer to a binary file on the file system. -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Images - store in DB or filesystem?
I already posted the JSP code, here is the CF equivalent that writes the file to disk and lets you view them. This doesn't take any more space either a while back christian cantrell blogged a method to streambinary data without much fuss: http://www.markme.com/cantrell/archives/002736.cfm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]