On 22 June 2012 10:21, Michele Comitini <michele.comit...@gmail.com> wrote:
> The DAL is a pure python implementation so it is slower than a C > implementation. > With large datasets the overhead is high so it is better to use executesql. > Often there's no other way than pulling all the records at once, but > sometimes a lazy approach to data extraction with the use of limitby > can give the best results: speed and DAL ease of use. > > I wish it was possible to use other time-saving tools like SQLFORM.grid with db.executesql(). At the moment most of the representation tools like SQLTABLE and plugin_wiki's jqgrid suppose DAL usage. Regards Johann -- Because experiencing your loyal love is better than life itself, my lips will praise you. (Psalm 63:3) --