I understand the pros and cons of db vs filesystem, and for images (static, rarely changing) it makes sense. I was pursuing any info about large chunk transfers or fragmented storage issues for large field tables.
I'm working with a table containing historical information for 67,000 stocks and indexes. Each record has a data field (mediumtext) which contains the csv data for the stock (approx 30K). Each record needs to be updated each night (append that day's row of data to the mediumtext field) and need to be available ASAP to all web-servers (currently 4).
The file is now about 1.5GB, and keeping/updating shadow copies of 70,000 files on 4+ nodes seemed like a problem which would not scale well. The read-side application will access less than 10% of the records in the database each day (but may access many records repeatedly).
bob.
At 07:50 AM 6/30/03 -0500, you wrote:
Bob:
This question comes up over and over on the list ... do a search for 'images' of the list archive and you can read the accumulated pros and cons.
Gerald Jensen
----- Original Message ----- From: "Bob Ostermann" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 30, 2003 7:35 AM Subject: Re: inserting images to mysql - is it possible?
> Armand- > > Why is it not recommended to store images in a database? I've not heard this... > > > bob. > > > > At 09:51 PM 6/29/03 +0200, you wrote: > >Hi, > >You have to insert a new blob field where you can store binary data. But > >it is not recommanded to store images in a database. I recommande you to > >store images on a server filesystem and only the reference to the images > >in a database. > > > >Armand > > > >Digital Directory USA wrote: > > > >>I am new to php and mysql, I have searched looked over and cannot find a > >>way to do this... can it be done? I have set up the following in mysql. > >>How do I upload the product images to the pPhoto column. Any suggestions? > >>ds_produc > >> Field Type Attributes Null Default Extra > >> pID int(11) No auto_increment > >> catID int(11) No 0 > >> pName varchar(70) Yes NULL > >> pNum varchar(40) Yes NULL > >> pTeaser text No > >> pDesc text Yes NULL > >> pPrice float(10,2) Yes NULL > >> pSalesPrice float(10,2) No 0.00 > >> pSale char(1) No > >> pPhoto varchar(70) Yes NULL > >> pPhotoWidth int(11) No 0 > >> pPhotoHeight int(11) No 0 > >> pSize varchar(35) Yes NULL > >> pAvail char(1) No Y > >> > >> > >>George Guebely > >>Digital Directory USA, Inc > >> > >> > > > > > > > >-- > >MySQL General Mailing List > >For list archives: http://lists.mysql.com/mysql > >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > ============================================== > The RediNews Network http://www.redinews.com/ > Custom Financial Web Site Content > phone: (516) 997-4343 > ============================================== > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > >
============================================== The RediNews Network http://www.redinews.com/ Custom Financial Web Site Content phone: (516) 997-4343 ==============================================
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
