[web2py] Re: VirtualFields are really slow with large datasets

2011-03-14 Thread Chris
I'm using virtual lazy fields, but I have a similar problem. It looks like it's only happening with one specific virtual field though. Here's my (abbreviated) comparison - dir is apparently slowing things down. With the virtual field of death enabled: 581186 function calls (580899 primiti

[web2py] Re: VirtualFields are really slow with large datasets

2011-02-16 Thread Carlos
You can also use lazy virtual fields, such that they execute only when needed/called: http://www.web2py.com/book/default/chapter/06?search=lazy Carlos

[web2py] Re: VirtualFields are really slow with large datasets

2011-02-16 Thread Massimo Di Pierro
Your virtual fields are doing one select for each record of the parent select. You should use joins. On Feb 16, 12:19 am, Kurt Grutzmacher wrote: > I have three tables that aren't particularly large (1500, 2500, and > 3500 records in each). With VirtualFields enabled a select() query > take a ver

[web2py] Re: VirtualFields are really slow with large datasets

2011-02-16 Thread KMax
I guess, virtualfield items gets their value by dedicated select, which give so much overheat.