Is creating new tables a bad idea?

–1 vote
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
asked Jan 14 in Smartform by Pomroy.dan Plater (170 points)

2 Answers

0 votes
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.
answered Jan 16 by coltest Listed class (2,860 points)
+1 vote
and make sure to create an index on any columns that you frequently use in a WHERE statement,,

otherwise the query will take ages.
answered Jan 18 by weston47 Plater (160 points)
edited Jan 23 by colin
...