Re: Caching/Indexing Function Output

On Thu, Dec 23, 2004 at 01:22:42PM -0800, Mike wrote:

> My question is- is there anyway, since a call to sp_host('10.0.0.1') will
> always
> return the same value (the primary key/sequence value from the ip_addresses
> table), to cache/index that value somehow, so anytime I ever call that same
> function, with the same argument, it returns a cached/indexed value?

Some procedural languages (PL/Tcl, PL/Python; also PL/Perl in 8.0)
have global data that you could use as a cache.  The function would
still be called each time, but you could at least use the cache to
save the cost of a database query.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/