LrTasks, SQLite and caching questions

Question

For the last couple of weeks, I've picked up Lua again and I've been trying to wrap my head around LrTasks and how to best use it.

I am working on a plugin that makes a call to sqlite using LrTasks.execute() to get some info from the catalog (that is not available via the SDK).

I am monitoring the time it takes for the task making the call using waitForGlobal function I found in the forums and the average is about 2-4 seconds.

The call works fine, but if I run the plugin again immediately to fetch the same info, the call time becomes zero and the rest of the codes executes before the call finished outputing the result to the temp file.

Any suggestions on how to fix this? What I am trying to figure out is:

Why is the second call time always zero?
Is there some caching happening or some other mechanism that I may not be aware of ?
Do I need to consider killing the task and if so, how?

Thanks

27shutterclicks · Accepted Answer

I think I figured it out, although there much still I need to understand of Lua.

I suspected that call time was 0 because the waitForGlobal function wasn't waiting at all, which means the check for the global to be nil failed. That meant that the global was still set to the old value, even after the plugin finished doing its thing and it was maintaining its value on subsequent runs.

To fix this, I simply forced the global variable to be nil at the beginning of the code, and everything worked out.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded