>> What you should do, is grab the 50 images ahead of time, in one select, and >> use some php to iterate them and display them. > > Second, your suggestion is not an option in my case, since the image and the > thumbnails are not stored in the database. The database contain image id, > image attributes (exposure++) and name of the image and thumbnail file.
That's all the data you need, I am not saying to pull the image out of the database, I am saying to pull the file path out of the database and put it in your html img src tag. Its the difference of making one call to the database, versus x, where x is as many thumbnails as you have, not to mention, x also represents that many http calls to your server, and also, that many times php must process that file. -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
