… or top sales people. This information may often need simple select query, however what if you would like to show percents … 290 | +——+—–+ 10 rows in set (21.12 sec) mysql> select count(*) cnt from dt where slack like “a%”; +———+ | cnt | +———+ | 2352996 | +———+ 1 row in set (…
Post: Using GROUP BY WITH ROLLUP for Reporting Performance Optimization
September 17, 2007 By 14 Comments
Post: Are you designing IO bound or CPU bound application ?
December 20, 2006 By 10 Comments
…MySQL Performance Optimization. In fact I probably have to touch it in every second MySQL…in the mailbox at least to draw “pager”. Easy solution is to do select…in trouble pretty soon even with 1000 messages in mailbox may start slowing things down. Now you may get few percent…
