2014-06-11
-
Laurent Bientz
2 methods better than a thousand words!
read_dir
rm_dir
More
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
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
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
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