This is a old version, I would suggest to try you app under at least to 1.99.4 and see if it improves.
Richard On Thu, Jul 5, 2012 at 5:08 PM, Santiago <[email protected]> wrote: > Hello, > > Do you know why the same query, takes more than 40 minutes to get resolved > using DAL and less than a second using raw SQL ? > > This is the code using DAL > > db(db.voting_center).select() > > This is the code using raw SQL > > db.executesql('SELECT voting_center.id, voting_center.election, > voting_center.full_id_indra, voting_center.latitude, > voting_center.longitude, voting_center.geometry, voting_center.circuit, > voting_center.name, voting_center.identification, voting_center.cue, > voting_center.annex, voting_center.source, voting_center.external_id, > voting_center.locality, voting_center.address, voting_center.provisional, > voting_center.definitive FROM voting_center WHERE (voting_center.id > > 0);') > > electoral-dev=# select count(1) from voting_center; > count > ------- > 66442 > (1 row) > > Column | Type | > Modifiers | Storage | Description > > ----------------+------------------------+------------------------------------------------------------+----------+------------- > id | integer | not null default > nextval('voting_center_id_seq'::regclass) | plain | > election | integer | not null > | plain | > latitude | character varying(512) | > | extended | > longitude | character varying(512) | > | extended | > circuit | integer | > | plain | > identification | character varying(512) | not null > | extended | > cue | character varying(512) | > | extended | > annex | character varying(512) | > | extended | > source | character varying(512) | > | extended | > external_id | character varying(512) | > | extended | > locality | character varying(512) | > | extended | > address | character varying(512) | > | extended | > provisional | integer | > | plain | > definitive | integer | > | plain | > geometry | geometry | > | main | > name | character varying(512) | not null > | extended | > full_id_indra | character varying(12) | > | extended | > > Thanks in advance > Santiago > >
