Comments
Sort by recent activity
Tilman wrote:
Hi Gail,
Every query window has its own candidate list in memory, so each query window needs to load the schema new. However, we do save the schema on disk the first time round and then read it from there, which should make things much quicker.
I noticed that behaviour later. It seemed like that time, it loaded from the database multiple times. Possibly because several connections were made to the database at once and no cache was stored for that db when the multiple connections were made.
Tilman wrote:
We do actually have keywords on the list, so you could argue that it should pop up. I do agree, though that the pop up behaviour can be improved and it is on our list of things to do. If it is annoying you a lot, you can turn off automatic pop up and only use Ctrl + Space.
True, but the keywords are at the bottom of the list. It would be nice if the popup in those places contained only the valid keywords for that point, but I guess that's a lot of work. Good to hear that it's getting looked at.
Tilman wrote:
Would it be possible to set an interval on cache refresh checks? Currently it appears as though every time I connect to a db, SQLPrompt checks the schema.
See above.
So it will only check the database once and load from disk after that? How often does it check the db for schema changes? / comments
Tilman wrote:
Hi Gail,
Every query window has its own candidate list in memory, so each query window needs to load the schema new. However, we do save the schema on disk the first time round and...
Would it be possible to set an interval on cache refresh checks? Currently it appears as though every time I connect to a db, SQLPrompt checks the schema.
Would be nice to be able to manage the interval per database. Every connection, once a day, once a week, etc
I love the auto insert functionality for alter and exec. Way cool! / comments
Would it be possible to set an interval on cache refresh checks? Currently it appears as though every time I connect to a db, SQLPrompt checks the schema.
Would be nice to be able to manage the int...