[web2py] Re: Slow queries or how to determine if cache is working?

2012-02-25 Thread Ray (a.k.a. Iceberg)
You only apply cache to your last query. You might need to cache the other two queries to gain full cache boost. Besides, you can add some profiling checkpoint inside your code to know which part is time consuming. Regards, Ray On Feb 25, 3:53 pm, pbreit pbreitenb...@gmail.com wrote: I'm

[web2py] Re: Slow queries or how to determine if cache is working?

2012-02-25 Thread Anthony
Is there any way to tell that caching is working? appadmin should include a menu with design, db, state, and cache. The cache link leads to /appadmin/ccache, which shows objects currently in the ram and disk caches, cache hits, etc. Anthony

[web2py] Re: Slow queries or how to determine if cache is working?

2012-02-25 Thread pbreit
Ah, right, thanks. I missed it because I don't use the default layout. I do notice, however, that while the cache does appear to be working, Web2py is reporting the cache size as 0: Size of cache: *0* items, *0* bytes The performance seems really slow, though since it's only running through

[web2py] Re: Slow queries or how to determine if cache is working?

2012-02-25 Thread pbreit
Also, on the 3rd or 4th draw on the cache it seems to just stall indefinitely (the categories in the side bar never display, it just shows loading... indefinitely. ps: sorry about the excessive quoting. Google Groups interface is giving me all sorts of problems right now. On Saturday,

[web2py] Re: Slow queries or how to determine if cache is working?

2012-02-25 Thread Anthony
Ah, right, thanks. I missed it because I don't use the default layout. I do notice, however, that while the cache does appear to be working, Web2py is reporting the cache size as 0: Size of cache: *0* items, *0* bytes Is it an older version of appadmin? In the current version, if you

[web2py] Re: Slow queries or how to determine if cache is working?

2012-02-25 Thread pbreit
OK, the problem is not query speed, it's that LOAD(...ajax=True) is really slow. I switched that to false and the page displays instantly now. But the appadmin/ccache page is still showing the cache at 0 even though it's recording hits (and db stats is not showing the query indicating that it

[web2py] Re: Slow queries or how to determine if cache is working?

2012-02-25 Thread pbreit
I realize that LOAD(ajax=True) could introduce a bit of a slow down but it seems much larger to me than I would expect. Does anyone else notice this? I originally used a bunch of ajax=True but I am switching to False and the pages are loading much faster. On Saturday, February 25, 2012

[web2py] Re: Slow queries or how to determine if cache is working?

2012-02-25 Thread Anthony
On Saturday, February 25, 2012 11:04:30 PM UTC-5, pbreit wrote: I realize that LOAD(ajax=True) could introduce a bit of a slow down but it seems much larger to me than I would expect. Does anyone else notice this? I originally used a bunch of ajax=True but I am switching to False and the

[web2py] Re: Slow queries or how to determine if cache is working?

2012-02-25 Thread Anthony
But the appadmin/ccache page is still showing the cache at 0 even though it's recording hits (and db stats is not showing the query indicating that it is getting it from cache). And that's after just updating to a current appadmin.py. You might need to update /views/appadmin.html as