I am Silvan Mühlemann, tilllate.com-Co-founder, jQuery and Zend Framework-Coder, Scrum-Master, Dual-Daddy, Runner
This blog reflects my thoughts on web technologies and management of web projects.
- Good Friday Run after celebrating my daughter's 10th birthday @ Uetliberg https://t.co/jzsPPHu0Gd 10:53:42 PM April 10, 2020 from Instagram ReplyRetweetFavorite
- Tough times in the world. Being a data and visualization geek, I also find something positive in it: Lots of stati… https://t.co/opANMGBsL1 07:04:17 AM April 07, 2020 from Twitter Web App ReplyRetweetFavorite
Tag Archives: mysql
If you want to store large amount of volatile data (e.g. log file entries) in a database with a constant storage memory footprint and no maintenance to purge the old entries, a round robin database is the best solution. But … Continue reading
There’s a number of pitfalls one should be aware of when working with AUTO_INCREMENT fields in MySQL. Last week, we fell in each of them: We have the table photos which contains all 15 million pictures on tilllate.com. This table … Continue reading
EXPLAIN is not the only way to analyze query perfomance im MySql because some things are not being taken into account. For example LIMIT clauses or the cost of the optimizer. There is also the mk-query-profiler. An interesting way to … Continue reading