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.