Separate queries to make use of the database indexes; with OR no index is used

thomascube

2008-08-07 ba0e7871bd85b631800bff13fc1a0a20f77751c5

 SQL/mysql5.initial.sql

@@ -54,6 +54,7 @@
 `headers` text NOT NULL,
 `structure` text,
 PRIMARY KEY(`message_id`),
 INDEX `created_index` (`created`),
 UNIQUE `uniqueness` (`user_id`, `cache_key`, `uid`),
 CONSTRAINT `user_id_fk_messages` FOREIGN KEY (`user_id`)
   REFERENCES `users`(`user_id`)