Using MySQL 4.0 already, but I'm pretty there are some people still using 3.x.
Maybe until 2.1 or (2.0.x) there could be two sourcefiles or a patch you could apply which introduced the 'not-so-efficient' code back again until people are given a chance to upgrade. It may not be worth the effort if too complicated, or if noone shouts out saying they can't upgrade, etc. /Mark > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Aaron Stone > Sent: Monday, 15 March 2004 1:01 a.m. > To: [email protected] > Subject: [Dbmail-dev] Bunch of fixes and improvements, but > with a catch > > > 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 > [email protected] > http://twister.fastxs.net/mailman/listinfo/dbmail-dev >
