Changeset 612 for trunk/install/phpwebgallery_structure.sql

Timestamp:

Nov 21, 2004, 12:13:48 PM (20 years ago)

Author:

plg

Message:

optimization : instead of reading each $confcalendar_datefield for
matching YEAR() and MONTH(), use of SQL statement BETWEEN ... AND ... on the
date field + new index image_i5 on date_creation (default date field for
calendar)

File:

• trunk/install/phpwebgallery_structure.sql (modified) (1 diff)

trunk/install/phpwebgallery_structure.sql

@@ -146 +146 @@
   KEY images_i1 (storage_category_id),
   KEY images_i3 (average_rate),
-  KEY images_i4 (hit)
+  KEY images_i4 (hit),
+  KEY images_i5 (date_creation)
 ) TYPE=MyISAM;