Pb with Mysql

[mellefou]

Hello,

I have a big probleme with EE 1.5 Beta 5 Fix 2.
When I launch photos/list.php?exhibition=1&pass=public&lang=eng

Fatal error: Maximum execution time of 30 seconds exceeded in c:\win32app\appserv\www\photos\list.php on line 769.

It's a problem whith mysql requete "mainstuff".

I launch this requete with MysqlFront and she takes more than 500 secondes.

Thanks for your help.

Steph

The rmysql requete :

SELECT
ee_photo.ee_photo_id, ee_photo_eng.ee_photo_header, ee_photo.ee_photo_exif_datetime, ee_lens_eng.ee_lens_displayname, ee_photo.ee_photo_exif_iso, ee_photo.ee_photo_exif_shutter,ee_photo.ee_photo_e xif_aperture, ee_photo.ee_photo_exif_mode, ee_photo.ee_photo_exif_metering, ee_country_eng.ee_country_name, ee_location.ee_location_name, ee_camera.ee_camera_model, ee_photo.ee_photo_shutter_unit, ee_photo.ee_photo_for_www, ee_photo.ee_photo_filename, ee_camera.ee_camera_manufacturer, ee_counter.ee_counter_value, DATE_FORMAT(ee_exhibition.ee_exhibition_start, '%M %D, %Y') AS exhibition_start_date, ee_exhibition.ee_exhibition_end, ee_owner.ee_owner_name AS photo_owner_name, UNIX_TIMESTAMP(ee_photo.ee_photo_sql_created) AS unixtime, ee_photo.ee_photo_panorama, ee_owner.ee_owner_name, ee_camera.ee_camera_id, ee_camera_eng.ee_camera_displayname, ee_photo_eng.ee_photo_exif_flash, ee_photo_eng.ee_photo_camerasupport, ee_photo.ee_light_id, ee_light_eng.ee_light_description, ee_photo.ee_photo_orientation, ee_photo.ee_photo_exif_zoom, ee_photo.ee_photo_exif_ev, ee_photo_eng.ee_photo_meta_keywords, ee_country_eng.ee_country_id, ee_camera_focal_multiplier,ee_order_to_exhibition. ee_order
FROM
ee_photo_eng USE INDEX (ee_photo_id),
ee_photo USE INDEX (ee_photo_id),
ee_lens,
ee_lens_eng,
ee_country_eng,
ee_location,
ee_camera,
ee_camera_eng,
ee_counter,
ee_photo_to_exhibition USE INDEX (ee_photo_id),
ee_exhibition,
ee_category_eng,
ee_photo_to_category,
ee_owner,
ee_order_to_exhibition,
ee_light_eng

WHERE
ee_photo.ee_photo_for_www = 'yes'
AND ee_photo_eng.ee_photo_id = ee_photo.ee_photo_id
AND ee_exhibition.ee_exhibition_pass = 'public'
AND ee_photo.ee_lens_id = ee_lens.ee_lens_id
AND ee_photo.ee_light_id = ee_light_eng.ee_light_id
AND ee_photo.ee_camera_id = ee_camera.ee_camera_id
AND ee_photo.ee_country_id = ee_country_eng.ee_country_id
AND ee_photo.ee_location_id = ee_location.ee_location_id
AND ee_counter.ee_counter_id = ee_photo.ee_counter_id
AND ee_photo_to_exhibition.ee_photo_id = ee_photo.ee_photo_id
AND ee_photo_to_exhibition.ee_exhibition_id = ee_exhibition.ee_exhibition_id
AND ee_photo_to_category.ee_category_id = ee_category_eng.ee_category_id
AND ee_photo_to_category.ee_photo_id = ee_photo.ee_photo_id
AND ee_owner.ee_owner_id = ee_photo.ee_owner_id
AND ee_photo_to_category.ee_category_id = '1'
AND ee_camera_eng.ee_camera_id = ee_camera.ee_camera_id
AND ee_lens_eng.ee_lens_id = ee_lens.ee_lens_id

AND ee_photo_to_exhibition.ee_exhibition_id = '1'
AND ee_order_to_exhibition.ee_exhibition_id = ee_exhibition.ee_exhibition_id
AND ee_order_to_exhibition.ee_photo_id = ee_photo.ee_photo_id
AND ee_exhibition.ee_exhibition_id = '1'


ORDER by ee_order_to_exhibition.ee_order DESC LIMIT 0, 10

[Pekka]

Make sure that you have at least 7 photos in database.

[mellefou]

Thanks for answer, I do the test, and it's work well now.

But I don't understand why?

[Pekka]

mellefou wrote:
Thanks for answer, I do the test, and it's work well now.

But I don't understand why?

MySQL will not use its internal cache system (indexes) if there is not enough data for it. EE is designed to use that system to fullest.