David, I haven't started evaluating 2.3 yet, but in the 2.2.* mysql is much faster then postgresql in searches and doesn't have as many problems.
Sometimes the low-end database is more appropriate for an application then the higher-end. Instead of being a database leetist it is worth determining needs based on the application. Sim David B. wrote: > first off, stop using mysql, it's for amateurs, > use postgresql. > > and yes, just use a trigger. > ---------------------------------------- >> From: [EMAIL PROTECTED] >> To: [email protected] >> Date: Wed, 3 Sep 2008 13:57:32 +0200 >> Subject: [Dbmail] trigger for new messages >> >> Hi there, >> >> I have one more question: >> >> the webmail system I wrote is almost done but at the moment I have >> something that is not really working as I would like it too: checking >> for >> new messages. I do that by polling the database for it, but I suppose >> you guys have a nice way to fix that via a trigger within the mysql db? >> >> Like having a table called: new_mail and update/insert entries there >> based on a MySQL trigger? I have no idea where and how I could >> put that into the current db scheme of dbmail without breaking/ >> generating other problems ... >> >> Thanks for your time! >> >> greetings, >> Daniel >> _______________________________________________ >> DBmail mailing list >> [email protected] >> https://mailman.fastxs.nl/mailman/listinfo/dbmail > > _________________________________________________________________ > Stay up to date on your PC, the Web, and your mobile phone with Windows Live. > http://clk.atdmt.com/MRT/go/msnnkwxp1020093185mrt/direct/01/_______________________________________________ > DBmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
