Hi, I've been using those references to images on the filesystem for 2 years now. What I experience, is that I have dead references, that means that I do have files on disk that don't exist in the database, and vica versa. Three weeks ago, I rewrote one part to see how things work if I store the images in MySQL. The 'broken reference' thing has been solved. Performance is ok if you don't do select *, but just select the columns you need (so don't select the blob if you dont need it). It works pretty good, place an index on the filename (or the ID), that's what you use mostly. It works good to, but if there are reasons not to use it, I can still 'undo' the change, so let me know! Regards, Harmen. "Felipe Moreno" <[EMAIL PROTECTED]> on 05/14/2001 04:46:10 PM To: [EMAIL PROTECTED] cc: Subject: [PHP-DB] Image and Mysql capabilities Hi list Members, I have a real doubt regarding the storage of images in the My sql database. Anyone know the alternatives to manipulate the insert and query with images? Well, let me explain...I have a lot of images that correspond to some "cars" names. I want, everytime a user select the respective car, to "bring" the respective car image with the informations of that car. I was reading about mysql, and found that it don't store images in the fields, but we can create a BLOB field and store it in binary. But, I'm afraid of the performance of the DB, cause sometimes you have thousands os images, and I know that it will occupy a lot of space!...So, I thought about putting a reference path to that image!...And print this path in a <img> tag...What do you think about it? Thanks 4 your attention, Regards, Felipe Moreno -----Mensagem original----- De: Mark Roedel [mailto:[EMAIL PROTECTED]] Enviada em: segunda-feira, 14 de maio de 2001 10:51 Para: Dragan Dinic; [EMAIL PROTECTED] Assunto: RE: [PHP-DB] php -> MSSQL > -----Original Message----- > From: Dragan Dinic [mailto:[EMAIL PROTECTED]] > Sent: Monday, May 14, 2001 5:11 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] php -> MSSQL > > > Is there any possible way to connect PHP (running on apache > 1.3.12 on Red Hat Linux 7) with Microsoft SQL server (running > on Windows 2000) ? Yep. As someone else has noted, the ODBC functions are one way. Another way, particularly if you prefer to talk to the database directly rather than through a translation layer, is to install the FreeTDS libraries (http://www.freetds.org/) on your Linux machine and then build PHP with the --with-sybase configuration parameter. This will enable the mssql_* functions. --- Mark Roedel ([EMAIL PROTECTED]) || "There cannot be a crisis next week. Systems Programmer / WebMaster || My schedule is already full." LeTourneau University || -- Henry Kissinger -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
