web developer & system programmer

coder . cl

ramblings and rants on software development...


Print Article R -a +A

query optimizations, quick recipes

by Daniel Molina Wegener on 2010.07.02
posted in: programming, sql, tips

Optimizing SQL queries is quite simple task, you just need to follow some rules on how you sort the filtering criteria and how you use your select statements. I will try to explain how you can optimize your queries in this post.

database usage rules

by Daniel Molina Wegener on 2010.04.23
posted in: programming, sql, tips

Modelling databases is not a simple task. Many times we found some misspelled words, mixed case words and some horrifying things on many databases of third party systems. My rules are simple to follow, and most of them ensures a well designed database, with special care on how do we query that database, creating reliable and optimised for speed table design and queries.