Z SQL Method - Advanced: Manage advanced settings

Description

Manage the advanced settings such as caching and plugable brains of a SQL method.

Controls

ID

Indicates the id of the sql method.

Title

Allows you to specify the title of the sql method.

Maximum number of rows retrieved

Specify an upper limit for the number of rows a sql method can retrieve. Setting this option correctly (based on your specific environment) can increase the execution time of the method.

Maximum number of results in the cache

Set the size of the sql method cache.

Maximum time (seconds) to cache results

The time in seconds that results are cached. Setting to zero disables caching.

Rows returned from this method can be turned into Result objects that are instances of a class you can specify below.

Class name

Allows you to specify the name of the Python class.

Class file

Allows you to specify the name of the Python module that the class is defined in. The class file should reside in the Zope Extensions directory.