5-10 Minute delay starting application and running query

[RickDMyers]

Describe the bug
Once logged into Salesforce the application takes about 5-10 minutes to start (show object tree).
Then when a query is executes, may take 5-10 before the result is returned, the application is locked during that period of time.

I am running on a very large instance of Salesforce (many objects and customizations).

Also running a on a MacBook with M2 processor.

To Reproduce
Steps to reproduce the behavior:

1. Start Application
2. Login to Salesforce
3. Wait 5-10 minutes for app to start

Same happens when running a query.

1. Run Query
2. Wait for response, 5-10 minutes.

Expected behavior
Older versions use to return right away.

Screenshots

Desktop (please complete the following information)

• OS: OSX 14.2.1
• CPU: M2 MAX
• Memory: 96GB
• SoqlX Version 4.6

Additional context

1. Seems like delay maybe loading the list of objects and properties for IntelliSense.
2. Would think load could happen in the background and should not be required in order to run a query.

[superfell]

When you say "older versions" do you know exactly which version you're referring to?

When you say the "app is locked" is it beach balling? the object metadata is all loaded in the background and shouldn't block the UI. Do you happened to have a very large query in the query box? This might be an issue with the syntax highlighting. You could try turning that off in the preference ("syntax highlight query") and restarting.

[brian-krynitsky]

I'm running into the same issue, however only for certain orgs and it doesn't seem to have a direct relationship to the number of objects. The org I log into almost instantaneously has more custom objects than the one that takes 10 min

[superfell]

Can you describe in more detail the behavior when there's a delay after login. What exactly is / isn't shown, is it beach balling? did you try turning off the "syntax highlight query" preference?

[cabiad-reach]

I have similar reproducible behaviour. Running 4.6 from homebrew under MacOS Ventura 13.5.2, but I am not sure if this is related to a version update. I suspect not due to the timing of it.

• You're correct that the app is beach balling in this state
• The main window appears, including the query text, but the metadata list is blank (no items visible in the "SObjects" list)
• Turning off the "syntax highlight query" preference works as expected (the query isn't highlighted) but has no effect on the slowness
• I notice that my "Recent queries" list's length is unaffected by the relevant setting. I've got it set to 10 and have many many more than ten items in my history. I've tried changing to 25 then back to 10 with no effect. I plan to try to figure out from the code how to manually blank out this history now.

[cabiad-reach]

Running defaults delete com.pocketsoap.osx.SoqlXplorer from the terminal is at least a work-around for the issue by blanking the recent queries (and any other persistent user configuration values). I am unsure if the app will start respecting the configured recent query limit going forward.

Edit: To be more explicitly clear, this completely solved the delay / slowness I was experiencing.

[superfell]

Thanks for the info. The recent queries list is truncated to the configured size only when a new query gets added to it. I can't imagine why anything related to that would cause it to beach ball. I'll have to have a look.

BTW, what do you mean by running from homebrew? I've never published anything to homebrew for soqlx.

[cabiad-reach]

SoqlX is available as a part of homebrew's "cask" database - https://formulae.brew.sh/cask/soqlxplorer