Re: Trouble with workbench

[Mike Lischke]

Ruben,

from what I see in the error message (I don't speak french) there's a timeout creating the result on the server when you run your stored procedure. Maybe because of a missing index or whatever.

But since this happens on the server I cannot see that MySQL Workbench makes trouble here. You sould probably first try to optimize your table structure and queries, but acting on 2.7M rows just takes some time.

Mike

Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github: https://github.com/mysql/mysql-workbench
On Twitter: https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/8.0/en/