PHP Classes

File: SQL File

Recommend this page to a friend!
  Packages of Matthew Asham   Binkterm PHP   database/migrations/v1.11.0.11_echomail_date_received_index.sql   Download  
File: database/migrations/v1.11.0.11_echomail_date_received_index.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Binkterm PHP
Bulletin board system based on the Web
Author: By
Last change:
Date: 5 days ago
Size: 320 bytes
 

Contents

Class file image Download 
-- v1.11.0.11 - Add index on echomail(date_received) for date range search performance
-- date_written already has an index; date_received did not, causing full table scans
-- when ECHOMAIL_ORDER_DATE is set to 'received' (the default).

CREATE INDEX IF NOT EXISTS idx_echomail_date_received ON echomail(date_received);