PHP Classes

File: SQL File

Recommend this page to a friend!
  Packages of Matthew Asham   Binkterm PHP   database/migrations/v1.9.3.6_add_echomail_msgid_index.sql   Download  
File: database/migrations/v1.9.3.6_add_echomail_msgid_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: 419 bytes
 

Contents

Class file image Download 
-- Migration: 1.8.1 - Add index on echomail.message_id for duplicate detection
-- This index improves performance of duplicate MSGID checks during packet processing

CREATE INDEX IF NOT EXISTS idx_echomail_message_id ON echomail(message_id);

-- Add index on combination of echoarea_id and message_id for faster duplicate lookups
CREATE INDEX IF NOT EXISTS idx_echomail_area_msgid ON echomail(echoarea_id, message_id);