hMailServer IssueTracker

242

Hello Martin,

First of all make clear that this is not an error.
This error is a performance problem that prevents the proper functioning of the feature "Message Indexing"

When the table "hm_messages" has much records and the feature "Message Indexing" is enabled hMailServer save the following error in log

"APPLICATION" 1484 "2009-08-14 00:04:38.086" "Severity: 2 (High), Code: HM5033, Source: DALRecordset::Open, Description: Source: ADOConnection::Execute, Code: HM10046, Description: Unknown error when executing SQL statement.
SELECT TOP 100 * FROM hm_messages WHERE messagetype = 2 AND NOT EXISTS (SELECT metadata_messageid FROM hm_message_metadata WHERE hm_messages.messagetype = 2 and hm_messages.messageid = hm_message_metadata.metadata_messageid)
Microsoft OLE DB Provider for SQL Server
Timeout expired"

One possible solution we have found to this problem is to create an index in the table "hm_message_metadata" . This is the query to create the index

CREATE NONCLUSTERED INDEX [hm_message_metadata_messageid] ON [dbo].[hm_message_metadata]
(
[metadata_messageid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]