Also, your request should not be : db().select(db.voting_center) instead of
db(db.voting_center).select()
Richard
On Thu, Jul 5, 2012 at 5:12 PM, Richard Vézina
<ml.richard.vez...@gmail.com>wrote:
> 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 <santiagogilab...@gmail.com>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
>>
>>
>
