Is creating new tables a bad idea?

Question

Hi,

I’m new to the MySQL Workbench for Smartform. I have merged the historic tables and added some new columns with calculations within the smartform connection, but now I am running into a 2013 error which indicates a connection drop between the MySQL client and the database server. Should I have created a new connection and linked it to the same database instead to allow for longer running queries?

Kind regards

Isabella

Answer 1

Hi - Smartform is a database, so it's fine to create new tables within it.  It is best not to modify the tables that are automatically updated but rather to create new tables which may be derived from these.

The issues with Workbench sound troublesome, but there are many other SQL clients available as well - dBeaver is a popular one.

Answer 2

and make sure to create an index on any columns that you frequently use in a WHERE statement,,

otherwise the query will take ages.