Re: [SQL] Query optimisation

2000-12-11 Thread Richard Huxton
From: "Michel Vrand" <[EMAIL PROTECTED]> > $conditions may be > > 1/ ...AND groupes.nom = '$something' AND > or > 2/ ...AND groupes.nom ~* '$something' AND > > In the first case, the query is reasonnably fast (0.30 s for 4 items on > 15000) > In the second case, the query becomes very sl

[SQL] Query optimisation

2000-12-11 Thread Michel Vrand
Hi! I first apologize for my poor english. We are working with linux-apache-postgresql-php3. One among our queries is structured as follow : $result = pg_exec ($conn, "SELECT produits.id_produit, produits.id_proprio, articles.categ, groupes.nom, produits.pvttc_prod, articles.titre, articles.type