Comments for Michi Knows http://www.michiknows.com Insights on the IT world by Michi Kono Tue, 09 Feb 2010 12:49:54 +0000 http://wordpress.org/?v=2.9.2 hourly 1 Comment on Neat Idea: Creating Alphanumeric IDs by miCRoSCoPiC^eaRthLinG http://www.michiknows.com/2008/02/17/neat-idea-creating-alphanumeric-ids/comment-page-1/#comment-15132 miCRoSCoPiC^eaRthLinG Tue, 09 Feb 2010 12:49:54 +0000 http://www.michiknows.com/2008/02/17/neat-idea-creating-alphanumeric-ids/#comment-15132 Thanks man. That was a big help. I was trying to implement something similar for generating tracking IDs for a certain application form at my workplace. The concept you explained here helped me do it in no time :) Cheers, m^e Thanks man. That was a big help. I was trying to implement something similar for generating tracking IDs for a certain application form at my workplace. The concept you explained here helped me do it in no time :)

Cheers,
m^e

]]> Comment on Make Text Come Out Backwards! by 420king http://www.michiknows.com/2007/01/31/make-text-come-out-backwards/comment-page-3/#comment-15129 420king Thu, 04 Feb 2010 06:19:33 +0000 http://michikono.com/blog/2007/01/31/make-text-come-out-backwards/#comment-15129 ‮ confused, what the fuck... ‮ confused, what the fuck…

]]> Comment on Make Text Come Out Backwards! by 420king http://www.michiknows.com/2007/01/31/make-text-come-out-backwards/comment-page-3/#comment-15128 420king Thu, 04 Feb 2010 06:18:54 +0000 http://michikono.com/blog/2007/01/31/make-text-come-out-backwards/#comment-15128 confused, what the fuck. confused, what the fuck.

]]> Comment on Make Text Come Out Backwards! by 420king http://www.michiknows.com/2007/01/31/make-text-come-out-backwards/comment-page-3/#comment-15127 420king Thu, 04 Feb 2010 06:16:51 +0000 http://michikono.com/blog/2007/01/31/make-text-come-out-backwards/#comment-15127 ‮ it didnt work ‮ it didnt work

]]> Comment on Who Else Wants to Hide Their Wordpress Folder? by priti http://www.michiknows.com/2007/02/12/who-else-wants-to-hide-their-wordpress-admin-folder/comment-page-2/#comment-15126 priti Tue, 02 Feb 2010 10:45:42 +0000 http://www.michiknows.com/2007/02/12/who-else-wants-to-hide-their-wordpress-folder/#comment-15126 Thxs for the gr8 trik :) Thxs for the gr8 trik :)

]]> Comment on Who Else Wants to Hide Their Wordpress Folder? by Joe http://www.michiknows.com/2007/02/12/who-else-wants-to-hide-their-wordpress-admin-folder/comment-page-2/#comment-15125 Joe Mon, 01 Feb 2010 19:35:35 +0000 http://www.michiknows.com/2007/02/12/who-else-wants-to-hide-their-wordpress-folder/#comment-15125 Thanks for this! This is incredible. Thanks for this! This is incredible.

]]> Comment on Make Text Come Out Backwards! by beeeca http://www.michiknows.com/2007/01/31/make-text-come-out-backwards/comment-page-3/#comment-15124 beeeca Sat, 23 Jan 2010 00:24:07 +0000 http://michikono.com/blog/2007/01/31/make-text-come-out-backwards/#comment-15124 ‮this doesnt work on facebook :[ what am I doing wrong? ‮this doesnt work on facebook :[ what am I doing wrong?

]]> Comment on The Secret of SQL_CALC_FOUND_ROWS by Tim http://www.michiknows.com/2007/08/07/the-secret-of-sql_calc_found_rows/comment-page-1/#comment-15123 Tim Thu, 21 Jan 2010 17:59:39 +0000 http://www.michiknows.com/2007/08/07/the-secret-of-sql_calc_found_rows/#comment-15123 btw: LIMIT 2,1 will return the third row, not the second row. btw: LIMIT 2,1 will return the third row, not the second row.

]]> Comment on Make Text Come Out Backwards! by connor http://www.michiknows.com/2007/01/31/make-text-come-out-backwards/comment-page-3/#comment-15121 connor Tue, 19 Jan 2010 22:16:40 +0000 http://michikono.com/blog/2007/01/31/make-text-come-out-backwards/#comment-15121 ‮silk ‮silk

]]> Comment on The Secret of SQL_CALC_FOUND_ROWS by Nick http://www.michiknows.com/2007/08/07/the-secret-of-sql_calc_found_rows/comment-page-1/#comment-15119 Nick Tue, 19 Jan 2010 05:17:16 +0000 http://www.michiknows.com/2007/08/07/the-secret-of-sql_calc_found_rows/#comment-15119 This is not "definitely faster" than using count(*). In fact, when I tried it, the result was many times slower than the original two queries combined. From the comments on http://dev.mysql.com/doc/refman/5.0/en/information-functions.html Posted by Wade Bowmer on May 14 2006 11:40pm Be aware that using SQL_CALC_FOUND_ROWS and FOUND_ROWS() disables ORDER BY ... LIMIT optimizations (see bugs http://bugs.mysql.com/bug.php?id=18454 and http://bugs.mysql.com/bug.php?id=19553). Until it's fixed, you should run your own benchmarks with and without it. This is not “definitely faster” than using count(*). In fact, when I tried it, the result was many times slower than the original two queries combined.

From the comments on http://dev.mysql.com/doc/refman/5.0/en/information-functions.html
Posted by Wade Bowmer on May 14 2006 11:40pm
Be aware that using SQL_CALC_FOUND_ROWS and FOUND_ROWS() disables ORDER BY … LIMIT optimizations (see bugs http://bugs.mysql.com/bug.php?id=18454 and http://bugs.mysql.com/bug.php?id=19553). Until it’s fixed, you should run your own benchmarks with and without it.

]]>