It would be doable, but reasonably complicated. I'm no database
programmer, but at the very least you'd have to redo DB.select, and
then DB.query which actually performs the select operation.
I'm not sure of your setup or project, but some good advice is to
avoid premature optimization. If you're actually running into
database performance issues (that aren't caused by weird hosting
setups...), you might want to look into some other database wrappers.
webpy's philosophy of "simple first" is quite present in the database
utilities (of course simple usually maps directly to speed...). For
any ORM like thing I'd recommend investigating SQLAlchemy.
If this is just something you're looking to do for fun, please don't
let me discourage you!
Good luck,
Justin
On Dec 5, 5:54 pm, pragmatic <[EMAIL PROTECTED]> wrote:
> Thanks for the info Justin.
>
> How hard would do you think it would be to implement this?
>
> I may poke around a bit in the code...
>
> On Dec 5, 4:23 pm, Justin Davis <[EMAIL PROTECTED]> wrote:
>
> > > This would still run two seperate queries (requiring two round trips)
> > > against the database, correct?
>
> > That's correct. webpy doesn't do anything like that right now.
>
> > On Dec 5, 5:01 pm, pragmatic <[EMAIL PROTECTED]> wrote:
>
> > > This would still run two seperate queries (requiring two round trips)
> > > against the database, correct?
>
> > > On Dec 3, 11:39 pm, Tzury Bar Yochay <[EMAIL PROTECTED]> wrote:
>
> > > > > For instance in ADO and ADO.NET you can execute multiple select
> > > > > statements and get back several recordsets. This usually helps
> > > > > performance quite a bit.
>
> > > > How about:
> > > > return [web.select('tableA'), web.select('tablB')]- Hide quoted text -
>
> > - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web.py" 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/webpy?hl=en
-~----------~----~----~----~------~----~------~--~---
