Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Slow row deletion with SSH

crafter2345's profile image crafter2345 posted 1 month 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 1 month 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 1 month 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 1 month ago Permalink

Not with the datagrid

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.