tag:blogger.com,1999:blog-15319370.post1659810188308592403..comments2024-03-05T11:16:00.846+01:00Comments on Roland Bouman's blog: MySQL: DIVide and Conquerrpboumanhttp://www.blogger.com/profile/13365137747952711328noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-15319370.post-67196116614333287942009-03-15T17:15:00.000+01:002009-03-15T17:15:00.000+01:00Great tip buddy.SamGreat tip buddy.<BR/><BR/>SamAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-15319370.post-30785258805605169242008-07-14T11:59:00.000+02:002008-07-14T11:59:00.000+02:00Hi Andrew, Joe,thanks!Joe: Like I wrote in the art...Hi Andrew, Joe,<BR/><BR/>thanks!<BR/><BR/>Joe: Like I wrote in the article, I don't expect that much from it, so I wouldn't hold my breath if I were you. However if your application is such that it simply needs integer arithmetic, it certainly won't hurt to use DIV, and it may give you some gains.<BR/><BR/>It would be cool if you could benchmark your real-world case, and post back some figures. Of course, if you experience some speedup, it does not mean it will be generally applicable, but it would still be interesting to see how much or how little difference it makes for your particular case.<BR/><BR/>Thanks in advance, <BR/><BR/>Roland.rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-41675107336793422842008-07-14T11:45:00.000+02:002008-07-14T11:45:00.000+02:00Roland,That's a fantastic tip! I've never come acr...Roland,<BR/><BR/>That's a fantastic tip! I've never come across that operator before.<BR/><BR/>I'm working on a very speed sensitive app that I've moved into memory tables to maximise speed.<BR/><BR/>I'm guessing that this will give me another boost.<BR/><BR/>JoeAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-15319370.post-81972335053077081492008-07-11T15:30:00.000+02:002008-07-11T15:30:00.000+02:00Hi,Nice tip! Thank you.Hi,<BR/><BR/>Nice tip! Thank you.Andrew Dashinhttps://www.blogger.com/profile/12832405604585874724noreply@blogger.com