efficient way to process data

Larry Martell larry.martell at gmail.com
Sun Jan 12 22:18:22 EST 2014


On Sun, Jan 12, 2014 at 5:18 PM, Chris Angelico <rosuav at gmail.com> wrote:
> On Mon, Jan 13, 2014 at 6:53 AM, Petite Abeille
> <petite.abeille at gmail.com> wrote:
>> On Jan 12, 2014, at 8:23 PM, Larry Martell <larry.martell at gmail.com> wrote:
>>
>>> AFAIK, there is no way to do this in SQL.
>>
>> Sounds like a job for window functions (aka analytic functions) [1][2].
>
> That's my thought too. I don't think MySQL has them, though, so it's
> either going to have to be done in Python, or the database back-end
> will need to change. Hard to say which would be harder.

Changing the database is not feasible.



More information about the Python-list mailing list