Gerrit P. Haase wrote:
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?
Two minutes? It can't be a dbmail issue then, can it.
This makes me think about other options. Wouldn't it be faster to store the actual messages on the harddisk?
And loose the main point of the whole dbmail concept. Currently you can plugin as many frontend servers as your database backend will suffer. But then, most of us don't need two minutes to retrieve a measly 200 rows from a postgres database.
Maybe you should change your platform instead :-) -- ________________________________________________________________ Paul Stevens [EMAIL PROTECTED] NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands_______________________________________www.nfg.nl
