at that point you miss formatting fields and references. In addition, 
db.executesql() doesn't return an iterator either. You should code your own 
exporter using db._adapter.execute() and a yielding fetchone()s.

On Wednesday, November 7, 2012 2:01:45 PM UTC+1, Johann Spies wrote:
>
> On 7 November 2012 14:05, Niphlod <nip...@gmail.com <javascript:>> wrote:
>
>> if your set doesn't fit into memory, saving it to a temp file won't get 
>> you out of troubles. One of DAL problems is that a Rows object does not 
>> return an iterator from the cursor, it's fetched all into memory first.
>>
>>
> In that case I would be inclined to use bypass DAL and db.executesql and 
> use the backend to export to a file.  That should be more efficient.
>
> Regards
> Johann
> -- 
> Because experiencing your loyal love is better than life itself, 
> my lips will praise you.  (Psalm 63:3)
>
>

-- 



Reply via email to