Hi,
1 10 seconds sounds way too short to me. I mean, apart from web
site/service, most software I`ve come across doesn`t really spawn
connections often (if at all) - a lot of people simply keep their
connections open and global. When they do open/close connections - it seems
perfectly plausible
Here are my issues/suggestions:
1. Generator ID. One for all is bad options for me. I'll reimplement it to
have one for table.
2. Couple of errors in creating Constraints or Indexes:
unsuccessful metadata update
Name longer than database column size
Constraint names are longer than it can be in