PHP5 : read_dir_recursive() and rm_dir_recursive()

2014-06-11
-
Laurent Bientz
2 methods better than a thousand words!
read_dir
rm_dir
More

XSL : Select distinct values (xPATH 1.0)

2014-01-28
-
Laurent Bientz
Imagine an XML stream composed of a collection of the same family (eg staff), each staff node has N skills and you want to know XSL distinct values ​​of all skills.
With xPATH 2.0, just use the function distinct-values():
With xPATH 1.0, the...
More

MySQL5 : MySQL Optimizations - Partioning by range

2013-08-05
-
Laurent Bientz
Since MySQL version 5.1 has many happy guys because finally provides support for the partitioning.
To put in context, by analogy with a hard disk, the partitioning of tables allows three main functionalities:
Properly organize their dataFaster...
More

MySQL5 : MySQL Optimizations - Group by and Count

2013-07-24
-
Laurent Bientz
2 good queries are better than good speech to understand which column choose to group when you want to get the count of a join.
The first query takes 12 seconds:
The second one take only 0.5 seconds:
These two queries produce exactly the same...
More

MySQL5 : MySQL Optimizations - Nested subquery

2013-07-24
-
Laurent Bientz
I think anyone who has had to analyze large tables to make reporting has already made such queries:
Except imagine that you have 1 million news, MySQL will perform 1 million and 1 queries to retrieve all:
1 query to retrieve 1M news1M queries to...
More
1 / 5

USER EXPERIENCE

Wandi invites you to discover a new approach to navigating a website...
Are you ready?

Launch the experience