thanks for the info. My main page seems to load a lot faster now. My site always has over 100+ guests online at once looking at pictures. A good day will be around 180.
Have you thought of doing more sql optimaztion. I'm not a pro, but I ran into this problem with OScommerce and 12,000 products. All the products are just in one table, products. I see in photopost all the images are in the table photos.
If it were broken up into more tables say like photo-a photo-b etc would that speed things up for sites with thousands of images?