When benchmarking your database, you have several options of data types, you must concentrate in all the possible data that you may have to store in a specific field.
Choosing the right data type will make all the difference when in production environment, the right MySQL structure will have the maximum performance, which means that your applications will run faster, however bad data types for certain data will kill your application.
If you are one of those persons that use VARCHAR for everything (or almost), you’ve been missing all the MySQL power.
Continuar a ler o artigo…
Etiquetas: benchmark, data types, database, EN, MySQL
It comes to a time when you need to optimize your code to the maximum. Usually most people do not worry to much about code performance or speed, this is a big mistake.
However, when you have your own server and less performance means more memory usage, you will get to the point the hard way. Most of the time, more memory usage means more hardware failure and server slow downs and down times.
Continuar a ler o artigo…
Etiquetas: database, EN, MySQL, on duplicate key update, performance, query, replace
It’s quite often to see at the end of some boards like SMF for example, the total number of the total queries made to the MySQL database.
I understand that some people believe that those queries are retrieved by an extra MySQL query, but the reality is that there is no query for that, so we have to do some extra PHP code.
Continuar a ler o artigo…
Etiquetas: count, database, db_query, EN, function, global, MySQL, mysql_query, PHP, php keywords, query, static
