mysqldump tips by crazytoon
Tuesday, January 23rd, 2007Our sysadmin has a nice blog post with a few tips for using mysqldump, especially if your database is used for more than a basic site, or if you have stored procedures and/or triggers.
Archive for January, 2007
Our sysadmin has a nice blog post with a few tips for using mysqldump, especially if your database is used for more than a basic site, or if you have stored procedures and/or triggers.
count(1) vs count(*) – any difference?
Friday, January 19th, 2007A while ago when I started my first job in LA, I was using MSSQL. I was told to never use count(*), and rather to use count(1). Several people insisted this performs better than count(*), and since I really didn't care to argue or look into it, I ...
Why have REPLACE INTO and INSERT … ON DUPLICATE KEY UPDATE?
Wednesday, January 17th, 2007REPLACE INTO will actually perform a delete and then an insert, while INSERT ... ON DUPLCIATE KEY UPDATE will perform an update (as the name suggests). I would think the latter would be faster. I have not done any performance testing between the two, but it only seems ...
Answerbag Read Write API Now in Beta
Wednesday, January 17th, 2007Although it's not officially announced, our read/write api is now out and in beta. It's not officially launched on the site or anything, but we are looking for interested partners. Docs are here