Am Donnerstag, den 08.12.2005, 13:46 -0800 schrieb Ed Colmar: > Do ZSQL methods communicate with the dtml-in call and understand the > "size" attribute?
Not really. > for example, in this dtml-in statement: > <dtml-in SQL_get_large_list size=20 start=query_start> > </dtml-in> > > Will the database be queried for all results, and only have 20 > displayed, or will the database just return the 20 that are needed? Well, this depends (in theory at least :) on the database adaptor. It could just fetch the results up to 20 but usually it will just fetch all and cut the batch out of it. This isnt so bad as it seems because you can have the ZSQL Method cache the result so the database isnt asked any time. You dont need DTML for batching. There is a batch module you can use in python scripts as well (and with ZPT) HTH Tino _______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
