You can do
db.executesql('....')
and pass any sql you want. If you show us what you need to do
specifically perhaps we can suggest a better way.
Massimo
On Aug 6, 1:13 pm, 陶艺夫 <[email protected]> wrote:
> Hi,
> I'm using PostgreSQL, I need to use stored procedure to calculate on more
> than 50000 records -- according to every people's birthday, figure out how
> much subsidy (s)he will get. Is this a rational idea?
> I have done calculating by a controller, but it has taken more than 50
> seconds to get the result. Is a stored procedure helpful for this? And how
> to do it in DAL?
>
> Thanks.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" 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/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
