[development] Request to remove some of my pages + ask confirmation for guidelines

Jean-Michel Pouré jm at poure.com
Fri Aug 28 07:18:25 UTC 2009

Dear friends,

First I would like to apologize for the flame-war about Drupal sending a
query returning 21.000 rows and computing it in PHP and then escalating
to Dries. I hope that my account will not be blocked and at the same
time I admit it was an error to escalate. 

But understand that I had no other choice because my issue were being
closed and my Drupal site was going to explode under load and I did not
know how to override this function. IMHO several Drupal users may have
experienced several slowdows due to this SQL query. 

So let's end it with my apologies.

On another front, I would like you to delete some of my pages, which are
crap and do not meet Drupal quality level:

Was: PostgreSQL cast. Proved to be wrong. ::int was a no-op.

Was: Replace whenever possible LEFT JOINs with INNER JOINs

The reason is that I found 1 query in my database which executes faster
as an INNER JOIN. So you were right to point out there is no clear rule.
This assumption was made when discussed several years ago with a
PostgreSQL core developer in an SQL submit. This is not the case in
100%, so let us the SQL planner decide.

I will continue my work writing;

I notice that sometimes the server is getting slow. I hope that this
will not make my life miserable.

I would like to use the name "MySQLism" to name some SQL extensions used
by MySQL. This is not a criticism. I treat both databases on the same
level and will call PostgreSQLism such things in PostgreSQL. If you
don't like, please tell me and I will not use such vocabulary.

Kind regards,

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: Ceci est une partie de message num?riquement sign?e
URL: <http://lists.drupal.org/pipermail/development/attachments/20090828/2b8ae054/attachment.pgp>

More information about the development mailing list