Bug #54938 Optimize start-up for MySQL Query Browser replacement
Submitted: 1 Jul 2010 16:49 Modified: 13 Jun 2013 20:38
Reporter: Tony Freixas Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S4 (Feature request)
Version:5.2.25 CE OS:Any
Assigned to: CPU Architecture:Any

[1 Jul 2010 16:49] Tony Freixas
Description:
As a MySQL Query Browser replacement, MySQL Workbench has some drawbacks that might be easy to remedy.

I use MySQL Query Browser as a utility: I run it, perform a task and exit. I would like a command-line option which optimizes MySQL Workbench to start up as a Query Browser replacement:

1. Start as though the application were running and I had clicked on "Open Connection to Start Querying" in the SQL Development section. First thing I should see is the connection dialog.

2. Do not load model files--this is a real time-waster when I don't plan to do modeling, it's great when I do. This might be useful as a separate command-line option.

3. Display the SQL Editor tab.

That's it. It still won't be as nice because the program just takes longer to start up, but it would make it a lot handier.

How to repeat:
Run MySQL Query Browser and try to get to the same point in MySQL Workbench. Note how much longer it takes, specially if there are a lot of model tabs being restored.

Suggested fix:
See above.
[6 Jul 2010 15:16] Alfredo Kojima
Good idea, following command line options would be nice if handled:

--start-query[=connection-name]
--start-admin[=instance-name]
[15 Jan 2011 5:07] Tony Freixas
I noticed that the command line options --admin and --query have been added in 5.2.31 CE and that these seem to implement my request, BUT...

1) On Windows 7, MySQLWorkbench.exe --admin Main doesn't work, but MySQLWorkbench.exe -admin Main does.

2) It still opened up the last used model, which slows down access to the admin features and defeats the purpose of having this command. The problem is that when I am using MySQL Workbench as a modeling tool, I want it to automatically open the last used model. When I use it in admin mode, I want to get to have a way to override this behavior. Maybe a --skip-model-load option?

3) The startup time of MySQLWorkbench -admin even with the model reload preference disabled is still much worse than MySQL Admin. I really wish the admin, query and modeling tools hadn't all been bundled into one—although if MySQLWorkbench had a faster startup time, it wouldn't matter.

4) MySQLWorkbench -help doesn't give help on the new command line options.
[13 Jun 2013 20:38] Philip Olson
Fixed as of the upcoming MySQL Workbench 6.0.2 public beta release, and here's the changelog entry:

The "--query" command line option was changed, the connection dialog will
be popped up directly if a value is not passed in.

Thank you for the bug report.