Quite often we come across situations where someone has a slow running database and it needs optimizing to make a web application or site work faster. A common thing we see in a number of inefficient databases is a lack of thought on the datatypes used to define fields in database tables, particularly in tables that are just used […]