Ilja Booij wrote:
Hi,
MySQL >= 4.0.14 does not seem like very bad thing to require.
Of course, we're using debian stable here, which still has 3.23.x as its
MySQL version.. But that shouldn't be too much of a problem :). We could
just install from source or the binary tarballs at mysql.com
Or add the following line to at the top of /etc/apt/sources.list
deb http://packages.dotdeb.org
This source supplies backports of MySQL and PHP to Woody
Magnus
We should go for the new statements! :D
Ilja
Aaron Stone wrote:
Hey,
So I was reading through the sorting code, and realized that the copy
of each
message from the temporary delivery user to the destination user was
much more
expensive than I thought. I have rewritten db_copymsg() to use just 3
queries,
where it used to be something like 10 queries!
The catch is that MySQL 4.0.14 or higher is required because prior to
4.0.14,
an INSERT INTO table1 ... SELECT FROM table2, where table1 == table2,
was not
allowed. All versions of PostgreSQL support this SQL92 compliant
query, though.
IMHO, this is a really important feature and it is well worth
excluding those
earlier MySQL versions to get support for it; Ilja, is that OK with you?
Aaron
_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
