Slow row deletion with SSH

crafter2345's profile image crafter2345 posted 3 years ago in General Permalink

Hello! I'm connected with my server via ssh, but it is so slow to delete for example 2.000 Rows take 30 seconds or like that. Directly in console (also connected with ssh) in a simple command it goes fast, but why? Do I make something wrong? Is ssh the problem? In filezilla it is the same problem, deletion of thousand of files takes so long, but with "rm cd/" it go fast.

ansgar's profile image ansgar posted 3 years ago Permalink

You can speed that up by typing the DELETE query in a query tab: DELETE FROM xyz WHERE whatever.

Deleting is done row by row if you do it in a grid in HeidiSQL. After each row HeidiSQL checks whether the deletion was successful, in order to remove it from the grid.

crafter2345's profile image crafter2345 posted 3 years ago Permalink

Isnt there a better solution where I dont have to write that down? It would be much more easier to mark the rows and delete them.

ansgar's profile image ansgar posted 3 years ago Permalink

Not with the datagrid

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