I know these queries can be optimized, so be gentle with the mocking. We've had no need to optimize them yet. Although a 4 minute result has made me start thinking it may be time...
(single folder, search for "monkey", 2774 messages in folder) select distinct b.mailbox_idnr, d.message_idnr, m.messagesize, b.name from messageblks d, messages m, mailboxes b where d.message_idnr = m.message_idnr and m.mailbox_idnr = b.mailbox_idnr and b.owner_idnr = 5 and b.mailbox_idnr = 78 and d.messageblk like '%monkey%' order by b.name, d.message_idnr; (all folders (15), search for "zombie", 21527 messages in my folders, 145273 messages total) select distinct b.mailbox_idnr, d.message_idnr, m.messagesize, b.name from messageblks d, messages m, mailboxes b where d.message_idnr = m.message_idnr and m.mailbox_idnr = b.mailbox_idnr and b.owner_idnr = 5 and d.messageblk like '%zombie%' order by b.name, d.message_idnr; -- Dave Logan http://www.digitalcoven.com/ "NO! Try not. DO! Or do not." -- Jedi Master Yoda
