MySQL Forums
Forum List  »  MySQL Workbench

Re: workbench hangs trying to load all tables in db
Posted by: J M
Date: July 18, 2014 12:01AM

Mike Lischke Wrote:
-------------------------------------------------------
> Hi,
>
> loading a large set of db objects can be slow,
> indeed, but that happens in the background and
> should not affect your work with WB. You can set a
> default schema in the connection settings that is
> used as the initial schema/db when connecting. Use
> a rather light schema there (e.g. I_S or mysql) to
> defer loading schema content to the moment you
> expand the schema node in the schema tree.
>
> Mike

Thanks, setting default schema to I_S does work but I have to provide explicit name e.g. my_db.my_table for every table in the query, It's perfectly usable but pretty annoying. There is a setting in prefs to disable auto-completion which I thought would be the rough equivalent of mysql -A but apparently not. I am dealing with a large db with very large number of tables and it's certainly not loading "in the background". WB becomes unusable as soon as I issue "use my_db"

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: workbench hangs trying to load all tables in db
894
J M
July 18, 2014 12:01AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.