On Thu, Nov 20, 2003 at 10:03:51AM -0800, Eric Soroos wrote:
> >Well, as you have stated there is a non zero possibility to get the
> >same fingerprint for two different messageblocks.
>
> Non-zero, but on the order of 1 in 2^127 chance, or virtually never in
> the age of the universe, at least
Well the first is something I have found out earlier, consider a table
with the fields A and B and the following records:
A B
1 1
1 2
2 1
for that record, you can not add the constraint UNIQUE(A) nor
UNIQUE(B), but you can add the constraint UNIQUE(A,B)
Correct. But if we're starting with A
Hello,
I've not seen one written to dump right from the db offhand,
but you could do so with a simple script (perl, php or /bin/sh
with a command-line sql client). It should also be fairly easy
to use something like fetchmail through the pop3 or imap interfaces
if you're only doing a small numb
Eric Soroos wrote:
On Nov 20, 2003, at 8:28 AM, Magnus Sundberg wrote:
Eric Soroos wrote:
You can. That's effectively what I was doing in my message, except
that you're not seeing it in the messageblk view. You probably
don't want a unique constraint on messageblk, since the idea of the
Roel Rozendaal - IC&S wrote:
ok that was not a very smart question as the log shows the timing. Main
problem is that your client is requesting the message in chunks of
10240 bytes which does not speed up things; the commands self are
pretty fast (1 sec each). I've noticed this behaviour of s
Bret Baptist wrote:
Can you try adding the -fomit-frame-pointers to your CFLAGS like described
below. Don't worry about the cpu flags.
-
On Friday 24 October 2003 5:35 am, Shih Ming-Wei wrote:
hi,
I have solve the 99% CPU usage on Linux/sparc systems that
we are using, apparent
On Nov 20, 2003, at 8:28 AM, Magnus Sundberg wrote:
Eric Soroos wrote:
You can. That's effectively what I was doing in my message, except
that you're not seeing it in the messageblk view. You probably
don't want a unique constraint on messageblk, since the idea of the
fingerprint is that it
Roel Rozendaal - IC&S wrote:
could you test on a telnet session to the imap server executing these
commands manually and timing them?
While it did give me a crash course in IMAP command structure, but I wasn't
able to fetch by hand as quickly as Mozilla did.
--
Lost in Tokyo,
Keith
Can you try adding the -fomit-frame-pointers to your CFLAGS like described
below. Don't worry about the cpu flags.
-
On Friday 24 October 2003 5:35 am, Shih Ming-Wei wrote:
> > hi,
> >
> > I have solve the 99% CPU usage on Linux/sparc systems that
> > we are using, apparently changi
Eric Soroos wrote:
You can. That's effectively what I was doing in my message, except
that you're not seeing it in the messageblk view. You probably don't
want a unique constraint on messageblk, since the idea of the
fingerprint is that it's a 1:1 mapping of the messageblk down to 128
bits.
ok that was not a very smart question as the log shows the timing. Main
problem is that your client is requesting the message in chunks of
10240 bytes which does not speed up things; the commands self are
pretty fast (1 sec each). I've noticed this behaviour of several
clients in an early s
could you test on a telnet session to the imap server executing these
commands manually and timing them?
Op 20-nov-03 om 17:03 heeft Keith Hopkins het volgende geschreven:
This was really, really SLOW
Nov 21 00:07:15 hades dbmail/imap4d[4121]: COMMAND: [52 UID fetch
358907 (BODYSTRUCTU
This was really, really SLOW
Nov 21 00:07:15 hades dbmail/imap4d[4121]: COMMAND: [52 UID fetch 358907
(BODYSTRUCTURE)]
Nov 21 00:07:16 hades dbmail/imap4d[4121]: COMMAND: [53 UID fetch 358907
(BODY[HEADER] BODY[1.MIME] BODY[2.MIME] BODY[3.MIME] BODY[4.MIME] BODY[5.MIME])]
Nov 21 00:07:16 had
You can. That's effectively what I was doing in my message, except
that you're not seeing it in the messageblk view. You probably don't
want a unique constraint on messageblk, since the idea of the
fingerprint is that it's a 1:1 mapping of the messageblk down to 128
bits.
I agree with you i
I am looking for a utility that will dump my email messages to stdout so
that I can run the output through spamassassin's sa-learn. Does anyone
have such a utility?
--joubert
Eric Soroos wrote:
Why can't you store the msg_block fingerprint in the msg_block table?
Like (with mysql syntax)
CREATE TABLE messageblks (
messageblk_idnr bigint(21) NOT NULL auto_increment,
physmessage_id bigint(21) NOT NULL default '0',
messageblk longtext NOT NULL,
blocks
16 matches
Mail list logo
