The latest MySQL Community Edition release, 5.0.67 will not be included in Debian Lenny as the distribution is frozen meaning no upstream new releases are going to be included into testing before lenny is released. Lenny will ship with MySQL 5.0.51a, while 5.0.67 (or a newer version if that will be the case) will be […]
Monthly Archives: June 2009
OpenWorld Begins
Rather than blog the events of an entire day, I’ve decided to dump my thoughts periodically.
This is more effective for me anyway, since to remember anything lately, I feel like I need to forget something else. So, a memory dump will happen eventually, better (or worse, depending) to get it recorded before the inevitable happens.
Here […]
what is faster, select count(*) or select count(pk) ?
Oh no, not another post about COUNT(*) and COUNT(1)
Well, it is not exactly the case. I just had the issue this morning that count(*) was too slow.
SQL> create table t as select rownum id,
2 lpad(’a',4000,’a') a,
3 lpad(’b',4000,’b') b,
4 […]