On 2/5/07, Christoph Haas <[EMAIL PROTECTED]> wrote: > > On Saturday 03 February 2007 08:01, dds wrote: > > Thanks for looking into the pagination stuff. > > No hope too soon. :) > > > On Jan 29, 11:54 pm, Christoph Haas <[EMAIL PROTECTED]> wrote: > > > The documentation > > > athttp://pylonshq.com/WebHelpers/module-webhelpers.pagination.htmlcont > > >ains this example: > > > > > > # In this case, Person is a SQLObject class, or it could be a > > > list/tuple person_paginator, person_set = paginate(Person, page=1) > > > > > > It wasn't very clear to me how that is supposed to work with > > > SQLAlchemy. It must look like this: > > > > > > person_paginator, person_set = \ > > > h.pagination.paginate(model.Person.select()) > > > > > > Can we please add that example to the the webhelpers/pagination/orm.py > > > module? > > > > But this is exactly what the paginator is supposed to avoid when using > > an ORM. You're selecting every person from the database, pulling it > > into memory, and making the paginator chunk it up. > > Are you sure? In the background the orm.py is creating a lazy mapping that > is only requesting rows from the database when they are needed. As far as > I understand even that .select() doesn't pull anything unless you read > from it. And if you read just a slice the database would *then* start a > query with a certain LIMIT. > > > The point of giving > > it a real query object is that it should use limit and offset to > > select only the elements from the DB to make the current page, not > > carry it all around in memory. > > True, but isn't that also true for .select()? I'm really not sure because > I'm a newbie to SQLAlchemy. Of course a "nakes .select()" is bullshit > because it does not contain any selection criteria.
Well, if you tell SQLAlchemy to echo queries to STDOUT, you can check that it's doing what you think it's doing. Best Regards, -jj > By the way... does anyone know if there's an easier way to create a query > than the long prayer version: model.session_context.current.query() ? -- http://jjinux.blogspot.com/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/pylons-discuss?hl=en -~----------~----~----~----~------~----~------~--~---
