Is your server’s clock ahead in time? Or is it in the past?
Well, here is the right time to set your date correctly, but how? It’s fairly easy in fact, just use rdate command.
rdate is a Linux command for immediate date and time setup from another machine.
Continuar a ler o artigo…
Etiquetas: EN
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
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
I recently had to install ffmpeg on a Dreamhost VPS client, but I’m sure that as long as you have shell access, you will be able to install it on any host. You don’t even need to have root access.
If you are looking for a way to install ffmpeg, follow the steps bellow and you will have no problems, as this is an exact transcription of what I did, and I had no problems.
Continuar a ler o artigo…
Etiquetas: bash, dreamhost, eaccelerator, EN, install eaccelerator, install ffmpeg, Linux, PHP, private server, PS, shell, ssh, vps