* This is the modus mailing list *
Check that you tables have been created properly and that you have
cascade updates and cascade deletes between the two tables.
If the two tables have the same number of rows, then it is likely to be
some other problem, however if they are way out off sync then you will
find that you are missing the cascades.
---
Statistics are like bikinis. What they conceal is more important than
what
they reveal.
(--------------------------------) {((((((
( Suneel Jhangiani ) /_ _ )
( Technical Director ) ( . . )
( Inter-Computer Technology Ltd. ) ( / )
(----------------------------------oOOo------------oOOo----)
( 40 James Street Tel: +44 (0) 20 7486 9601 )
( London W1U 1EU Fax: +44 (0) 7050 678 978 )
( United Kingdom Email: [EMAIL PROTECTED] )
( Website: http://www.inctech.com )
(----------------------------------------------------------)
-----Original Message-----
From: Christian Schmit [mailto:[EMAIL PROTECTED]
Sent: 10 November 2003 20:32
To: [EMAIL PROTECTED]
* This is the modus mailing list *
We use MS-SQL-2000 server as quarantine database.
We noticed the no quarantine entries get deleted
in the SQL database after the auto-cleanup time,
which is 5 days in our setup. Therefor we
have millions of entries in this database which
makes searching quite slow.
So my question is should we delete the quarantine
entries in SQL ourselves or should modusmail
handle this?
The items in the quaratine mailbox on the server
get deleted as they should after 5 days.
Currently we run MM 3.0 but the problem also existed
with version 2.x for us.
Christian
**
To unsubscribe, send an Email to: [EMAIL PROTECTED]
with the word "UNSUBSCRIBE" in the body or subject line.
**
To unsubscribe, send an Email to: [EMAIL PROTECTED]
with the word "UNSUBSCRIBE" in the body or subject line.
