Hello everybody. I'm new to this group and am working on a social networking site project using Pylons. We are using elixir, because it suits our needs perfectly. However I would like to ask you if there is some way to execute ranged selects?
What I mean by this? Well I'm creating a list display widget and this widget has pages. I'd like to show for example ten entries per page. I was wondering if there is something that would count all elixir objects, and then create "batches" of them with this per-page count. For example something like this: entity_list = model.Place.query().filter_by(batch_count = 10, batch_number = 3).all() This will return object list 30 to 40 from database. Is it somehow possible? Of course I could do it by executing query().all() and then selecting batches programatically, but when I'll have thousands of objects and thousands of users at the same time this would mean significant performance impact. Any ideas? Regards, Karol Tomala --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SQLElixir" 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/sqlelixir?hl=en -~----------~----~----~----~------~----~------~--~---
