I did following steps to upgrade: 1. From admin panel, I cleaned, caches, sessions and errors using "clean". (also cleaned my browser cache and cookies) 2. Then created w2p package using "pack all" 3. Downloaded latest web2py 2.14.6 from http://web2py.com/init/default/download 4. Then installed w2p package on web2py 2.14.6 using admin panel 5. Copied web2py.js, appadmin.py, appadmin.html, jquery.js, web2py_ajax.html, web2py.css from welcome app and pasted in newly installed app 6. Made few css changes to match old UI Now my complete app is running without any python or js errors.
Now when I visit application page containing web2py grid (SQLFORM.grid()) on web2py 2.14.6, it takes *34.775* *seconds* and on version 2.3.2 same page with same number of records it takes *0.686* *seconds*. Grid has around 4600 records. Pages that doesn't have grid, took approx same time to load on both versions. I did time profiling and found that gluon/html.py is taking most of the time. Time profiling results 2.3.2 : https://paste.ubuntu.com/23602259/ 2.14.6 : https://paste.ubuntu.com/23602261/ Also I added print statement before and after grid definition, It took 18 seconds on 2.14.6 and 10 *miliseconds* on 2.3.2. SQLFORM.grid() definition is similar to following: grid = SQLFORM.grid(query, create=True, csv=False, deletable=False, searchable=search_query, showbuttontext=False, links=links, links_placement='left', maxtextlengths=textlengths, upload=URL('download'), fields=[db.notice.UIN, db.notice.classname, db.notice.title, db.notice.type, db.notice.description, db.notice.due_date, db.notice.status, db.notice.risk, db.notice.consequence, db.notice.document, db.notice.other]) sample query in above grid- ((((user_notice.notice = notice.id) AND (user_notice.auth_user = 19)) AND (notice.status IN ('Closed','Open','New'))) AND (notice.due_date IS NOT NULL)) I tested this on my local computer- Ubuntu 14.04, Python 2.7.6, development server and mysql db. Why newer version takes more time to load grid? Anything I missed while doing upgrade? Please help me to solve this issue. Thank you -- 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 message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
