Tuesday, March 13, 2012

Re: Using DictCursors

I believe this is not a cloud-sql but an app engine issue. The problem is that dict cursor is not implemented in one or both of the app engine python sdk version (can't remember exactly).

I remember having the same exact issue and I what I did was to copy the implementation from dict cursor and kind of mock it that way. 

Spoiler alert: In my particular case, the performance was terrible because the dict cursor basically copies the data into a dictionary one result row at the time, while this happens the mysql connection remains open and the performance of the copy operation itself was terrible, at least for the result set I was working with (this might be different in your particular use case/dataset).


No comments:

Post a Comment