Monthly Archives: April 2011

Faster Alternative to PHP’s Array Unique Function

Using PHP’s function array_unique() allows you to take an array of values and remove the duplicates leaving you with an array with unique values. This function works best most of the time, however if you find yourself trying to use array_unique on massive arrays, it may slow down quite a bit. Instead of using array_unique [...]

MySQL DELAYED INSERT – A MySQL Syntax Tip

When performing MySQL queries on your websites, there can often be a delay in a page loading while a MySQL Query is busy executing and returning the result. Generally the delay is minimal however on large complex queries with lots of join across multiple tables and millions of rows of data, there will be a [...]

MySQL INSERT IGNORE – A MySQL Syntax Tip

In MySQL, when you perform a mysql insert statements, it is almost inevitable that you will come across errors during the insert every so often. Once an issue is encountered with a mysql insert, the rest of the mysql inserts will not be imported since the MySQL query won’t continue. This can be annoying since [...]