Currently, deleting large chunks of data from a table using the OOo UI is
painfully slow: For instance, try a table with several thousand records, display
it in the data source browser, select all rows, and delete them (via the context
menu). This takes several seconds, up to minutes.
Given that the database server itself can usually handle this in much less time
(less than a second), this is .... awkward.

We should (per a option, which is to set globally or per data source) allow fast
deletion: We could examine the filter which is currently used to display the
table, and generate a statement such as "DELETE * FROM <table> WHERE <filter>",
instead of manually iterating through all affected rows and deleting every row
on it's own.

The drawback of such an approach is that in multi-user scenarios, it's possible
that other users added data (which fulfills the filter which is used on the
table view) to the table in question, so that a DELETE statement may affect
them, too. This, at least, indicates that the "fast delete" should be optionally
(while a different approach would be to ask the user, with a "never ask me
again" checkbox).


Additionally or alternatively, we should at least evaluate the usage of prepared
statements, which are filled in with the current key only - this would propably
speed up deletion, too.