[sqlite] Query takes ages

I have a query that takes ages ... my app remains in the first sqlite_step for more than 30 minutes (with 100% CPU time). Query is: SELECT reseaux.name, reseaux.id_reseau, reseaux.insee_id, panneaux.insee_id, panneaux .reseau_id ,insee .commune ,afficheurs .societe,reseaux.name,reseau

Re: [sqlite] Query takes ages

On 24/04/2009 2:16 AM, Marco Bambini wrote: > I have a query that takes ages ... my app remains in the first > sqlite_step for more than 30 minutes (with 100% CPU time). > Query is: > > SELECT reseaux.name, reseaux.id_reseau, reseaux.insee_id, > panneaux.insee_id, > panneaux > .reseau_id >