Sounds like it would be good to have in place as soon as possible, so those of us using new versions can get the optimizations.
Maybe a compile-time option or something for 1-2 months? Or perhaps a runtime check -- call the select version() function and make sure is high enough, etc. /Mark > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Aaron Stone > Sent: Monday, 15 March 2004 7:46 a.m. > To: dbmail-dev@dbmail.org > Subject: RE: [Dbmail-dev] Bunch of fixes and improvements, > but with a catch > > I'm fairly certain that we're already using features of > 4.0... although I > agree that if we're not yet requiring 4.0 in the first place, > then it's > somewhat silly to discuss which revision of 4.0 should be the minimum. > > It wouldn't be hard to switch back to the previous pair of > queries, but it > sure would be nice to use the single query! > > Aaron > > > "Mark Mackay - Orcon" <[EMAIL PROTECTED]> said: > > > 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: dbmail-dev@dbmail.org > > > 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 > > > 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 > > > > > > -- > > > > _______________________________________________ > Dbmail-dev mailing list > Dbmail-dev@dbmail.org > http://twister.fastxs.net/mailman/listinfo/dbmail-dev >
