distal-attribute
distal-attribute
distal-attribute
distal-attribute

deleting rows from table

Rui Barbosa posted 2 weeks ago in General

why sometimes ctrl+del doesnt work to delete rows ? and why does it take so much time to delete multiple rows (200 or soemthing like that)

ansgar posted 2 weeks ago

Deleting rows in the data grid is a bit slow because there are some special cases to keep in mind for HeidiSQL. For example, a row is by default loaded with the first 256 characters in text columns only, for performance reasons. Now when you delete a row, HeidiSQL has to make sure it has the full data, because on a table without primary or unique key, it has to take full data into the WHERE clause of the DELETE command.

In short, deleting in the data grid is quite safe, but slow. Deleting via custom query can be equally secure but faster. However, that needs deeper knowledge about the table in question and its keys, and that is more writing work.

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