xp_fileexist encapsulated in a function.

[Jamfool]

ok we have basically created a function which uses the existing undocumented xp_fileexist to check for a file but wrapped it in an existing function.

e.g

dbo.fnFileExists (filepath) which returns a bit

The first time this runs it takes 4-6 seconds, but the second time it is almost instantaneous. obviously this is being cached, but an hour later it is back to being slow.

Can the results of this be cached for longer?

Any advice would be great, thanks.