[web2py] Re: using database record or database query in terms of performance

2015-06-13 Thread 黄祥
i use snakeviz it can run well on windows pip install snakeviz python C:\web2py\web2py.py -F C:\profiler - delete all files on profiler folders - access the controller file that want to measured - then check the biggest size file on profiler folder e.g. snakeviz

[web2py] Re: using database record or database query in terms of performance

2015-06-12 Thread Niphlod
do option 1) , then option 2), then profile, then choose. Anything else is rubbish. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this

[web2py] Re: using database record or database query in terms of performance

2015-06-12 Thread 黄祥
profile is it same like https://docs.python.org/2/library/profile.html or web2py profile i've test something like python web2py.py --profiler=C:\profiler but the result i got in the profiler folder is *.prof file, when i open it, it seems to semi human readable file. don't know how to do with

[web2py] Re: using database record or database query in terms of performance

2015-06-12 Thread Niphlod
profile in your case is simply a matter on how much time it takes. On Friday, June 12, 2015 at 8:59:53 AM UTC+2, 黄祥 wrote: profile is it same like https://docs.python.org/2/library/profile.html or web2py profile i've test something like python web2py.py --profiler=C:\profiler but the

[web2py] Re: using database record or database query in terms of performance

2015-06-12 Thread Dave S
On Thursday, June 11, 2015 at 11:59:53 PM UTC-7, 黄祥 wrote: profile is it same like https://docs.python.org/2/library/profile.html or web2py profile i've test something like python web2py.py --profiler=C:\profiler but the result i got in the profiler folder is *.prof file, when i open

[web2py] Re: using database record or database query in terms of performance

2015-06-12 Thread 黄祥
any idea how to generate the profile with cprofile on a web2py app that supports database access? i've tried but it return an error C:\Users\sugizopython -m cProfile -o c:\profiler\profile.profile C:\web2py\applications\test\controllers\transaction.py Traceback (most recent call last): File

[web2py] Re: using database record or database query in terms of performance

2015-06-12 Thread Dave S
On Friday, June 12, 2015 at 5:08:36 PM UTC-7, 黄祥 wrote: i've tried but none is shown when using runsnake and the error traceback occured when using cprofilev. any idea? step i took on win 7 ultimate 64 with python 2.7.8 : pip install cprofilev easy_install SquareMap RunSnakeRun python

[web2py] Re: using database record or database query in terms of performance

2015-06-12 Thread 黄祥
i've tried but none is shown when using runsnake and the error traceback occured when using cprofilev. any idea? step i took on win 7 ultimate 64 with python 2.7.8 : pip install cprofilev easy_install SquareMap RunSnakeRun python C:\web2py\web2py.py -F C:\profiler C:\Users\sugizorunsnake