Out 05 2008

Speed Up MySQL: Replace or On Duplicate Key Update?

Categoria: MySQL=IceBurn= @ 17:57 — 608 visualizações

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: , , , , , ,


Out 02 2008

Count & Display The Total Number of MySQL Queries

Categoria: PHP=IceBurn= @ 18:42 — 869 visualizações

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: , , , , , , , , , , ,