Does the 'maximum number of results to cache' value refer to the number of different result sets that get cached for the same ZSQL method, or is it the number of rows that get cached? Also, is spacew pre-allocated, so do I want to worry about setting values too high for queries that will only ever return a single result set, or does it not matter? If I set the max rows to 0, does that return an infinite number of rows? --sam -- -------------------------- Sam Gendler CTO, Impossible, Inc. 1222 State St. Suite 250 Santa Barbara, CA. 93101 p: 805-560-0508 f: 805-560-0608 c: 805-689-1191 e: sgendler@impossible.com