prabowomurti / sequel-pro

Automatically exported from code.google.com/p/sequel-pro
Other
0 stars 0 forks source link

Duplicate table content by default #727

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
When duplicating a table I believe the "Duplicate table content" option MUST be 
selected by default. 

It's not a huge issue if table contents are duplicated accidentally, but it 
might be a very big problem if table contents are not duplicated when that was 
intended.

Original issue reported on code.google.com by t...@me.com on 10 Jun 2010 at 5:58

GoogleCodeExporter commented 9 years ago
I disagree.  Try accidentally duplicating a 13M record table.  

I highly doubt having to delete the new table and re-duplicating would cause a 
"very big problem", but having to wait for huge tables to repopulate and 
potentially causing a logjam in your mysql server would be an actual "very big 
problem".

My opinion, of course.

Original comment by mainstre...@gmail.com on 10 Jun 2010 at 1:09

GoogleCodeExporter commented 9 years ago
I'm afraid I agree with Mark on this one. Aside from potentially locking up 
your database in the event of accidentally duplicating the content of a very 
large table, there's also the possibility of disk space issues as a result of 
doing so. I'd class these as 'very big problems' which could take a 
significantly longer time to resolve than forgetting to duplicate the content 
of table and then immediately noticing once your application is not performing 
as expected.

Thanks

--
Stuart Connolly
Sequel Pro Developer  

Original comment by stuart02 on 10 Jun 2010 at 2:01