FYI
select * from dbmail_messageblks;
(5,075 InnoDB 48.4 MB )
5075 rows in set (0.54 sec)
mysql>
SunOS5 MySQL4.0.21Max
Gerrit P. Haase wrote:
Hello Matthew,
Second reply to this mail:
Ok, I'm running this on Windows using Cygwin postgres / dbmail,
everything is usually 10 to 100 times slower, but I know that database
applications can run fast on Windows too. Sure, Cygwin slows down
things. I installed it on the Windows box for testing, at least it
builds ok and it runs. But often dbmail seems to hang. It finally
finishes the work but I suspect htere to be some serious problems.
At this point I would recomend installing the PostgreSQL 8.0 beta that
has native support for Windows. Even though it's still a beta I think
it performs better and is probably more reliable than the cygwin port.
Please give it a try and let me know if you are still having problems.
I have the native Windows version of postgres installed now. It is
still very slow. I did a `select * from dbmail_messageblks` and it
lasts about two minutes to fetch 100 rows! This is very slow, and I
don't think that the Cygwin version is much slower here. Why is this
so slow?
This makes me think about other options. Wouldn't it be faster to
store the actual messages on the harddisk?
Gerrit
