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.

Connection Hook

Specifies the id of a method to be called when the database connection is made. This method will return a string containing the id of the database connection to use. If left blank there is no effect, the connection id specified will be used.

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.