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
CSS brought us so many possibilities! Luckily, I’ve started my first HTML pages, back in 2004, using style sheets, so the old table based layout that old school designers still use these days simple because they stopped in time 10 years ago, are history.
Now that the possibilities are almost infinite, we started using more and more CSS in web design/(X)HTML structure. But most people forget the essentials, the page loading time and bandwidth spent.
Continuar a ler o artigo…
Etiquetas: bandwidth, compress, CSS, CssShrink, EN, load, PHP, php class, uncompress
Sessions are advantageous for activities such as performing log in operations and associating a logged-in user with consecutive requests, tracing multiple-stage online ordering processes and more.
However HTTP is a stateless protocol, which means that web servers treat every request independently of any other. This is where server-side session storage kicks in, but there’s still some security risks.
Continuar a ler o artigo…
Etiquetas: class, code, MySQL, mysql sessions, PHP, script, secure, security, session handler, sessions;EN
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
Usually just because you have your site hosted on a server located in the other side of the globe, does not mean that you have to relay on the server’s time zone.
There are several methods, I’ve used a couple of them myself in the early days when developing my first scripts.
Most of them consisted in setting the time zone in runtime, but sometimes it’s not an easy task, especially when you have a code that is not ready or is not well organized. That means you had to edit each file, setting the time zone.
Continuar a ler o artigo…
Etiquetas: Apache, EN, mod_setenvif, override, PHP, putenv, time zone, timezone, tz
