Posted by NC on 05/25/07 20:33

On May 25, 2:36 am, andre rodier <andrerod...@free.fr> wrote:
>
> I am looking for a PHP library able to create on the fly
> complex SQL requests, on 5 or 6 dimensions, without
> problems occurs on many-to-many relations, etc.

You are looking for the impossible. Generally, the more complicated
your SQL is, the less efficient the use of abstraction layers
becomes. There is a reason why database architecture exists as a
trade separate from both programming and system administration.
Choosing the right order of tables in a complex join or forcing an
index can sometimes increase execution speed by a factor of 200...

Cheers,
NC

[Back to original message]