Fetching Schema taking long with SQLite database
I have many queries against a SQLite database and usually have these open in LINQPad for days. From time to time, I'll switch to LINQPad, paste a new parameter value into one of these scripts that had previously been run, and when I execute it, I find that Fetching Schema takes a long time or never completes.
How can I diagnose this? I presume there must be a log that will show me what's happening.
Comments
I should have mentioned that the database schema is not large by any definition having only ten or so tables (at work now so can't check my home PC right now).
I'm wondering if this could be some kind of file locking problem.
When this happens, does it fix it when you right-click and choose 'Refresh'?