Locking data view when connection is lost

[expired user #8958]'s profile image [expired user #8958] posted 9 years ago in General Permalink
First off thanks for a great product, I use it at work and it is great.

However I just installed it at home, and I am experiencing a frustrating problem. This is related to this issue http://www.heidisql.com/forum.php?t=13510. I am also having the same problem with the 10 second timeout. But I don't want to change the mysql settings.

I am frustrated because the data display gets disabled when the connection is lost and I cannot even view the data anymore because the scrollbars are also disabled.

Since the data does not update real time I don't see why it needs a persistent connection? Why can't I query some data, have it disconnect, make changes and when I save it reconnects and submits the update query to the server?

Am I missing a setting somewhere that allows this?

Thanks
ansgar's profile image ansgar posted 9 years ago Permalink

Why can't I query some data, have it disconnect, make changes and when I save it reconnects and submits the update query to the server?



Because the data in the grids are not loaded once in a big bunch. HeidiSQL loads the grid rows in chunks of 1000 rows by default, and only the first 256 characters of text columns. When you start editing data, by pressing F2 in a grid cell for example, HeidiSQL loads the whole text columns of the row.
[expired user #8958]'s profile image [expired user #8958] posted 9 years ago Permalink
Solutions
1. Cache the data so it loads without a database connection.
2. Open a new connection and query the database when I edit.

Please login to leave a reply, or register at first.