Just for kicks, I downgraded to 0.23, and performance (at least for my
use cases) is significantly better than with 0.31.
web.py 0.31 with charset=None
Database time: 176 ms
Render time: 183 ms
Total time: 360 ms
web.py 0.23
Database time: 104 ms
Render time: 124 ms
Total time: 228 ms <---- 37% faster
On Jan 3, 10:20 am, mb <[email protected]> wrote:
> Looks like that's the problem. After setting charset=None, response
> time is better.
>
> With the web.py database module, charset=None
> Database time: 176 ms
> Render time: 183 ms
> Total time: 360 ms
>
> With the web.py database module and unicode:
> Database time: 172 ms
> Render time: 176,087 ms <---- Here's the problem
> Total time: 176,260 ms
>
> With MySQL-python 1.2.2 instead of the web.py db module:
> Database time: 127 ms
> Render time: 71 ms
> Total time: 224 ms
>
> On Jan 3, 9:56 am, "Anand Chitipothu" <[email protected]> wrote:
>
> > > So it looks like I can work around the issue by using MySQL-python
> > > instead of the new web.py database module. Or I could revert to
> > > version 0.23 since it works fine, and this appears to be a new issue
> > > with 0.31.
>
> > In web.py 0.3x, there were some changes to MySQLDB to return unicode
> > values from the resultset. That could be causing the trouble.
> > It can be disabled by passing charset=None to web.database function
> > when creating the database.
>
> > Can you please try with that option and let us know the execution time?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
