I think this is actually a good question to ask, but it's a separate question and better answered by someone more involved with DBConnect's development. Can you post it separately? For the record, I doubt that the database lookup caches the lookup rows locally and I don't see any mention of such functionality in the docs.
Is the lookup literally running out to SQL Server in real-time, or does it run it real-time the first time and then cache the results for later use?
(In this case, using dbquery to populate the pulldown is not ideal because of the customizable/fluid nature of the form. I'm trying to be as dynamic as possible and use ValueSetter modules to control the order of Pulldowns. I know, it's weird.)