Issue 15202 - [RFE] allow faster deletion of table data
Summary: [RFE] allow faster deletion of table data
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 Beta2
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2003-06-02 11:41 UTC by Frank Schönheit
Modified: 2013-08-07 15:45 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description Frank Schönheit 2003-06-02 11:41:16 UTC
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.
Comment 1 Frank Schönheit 2003-06-02 11:41:34 UTC
accepting and targeting
Comment 2 Frank Schönheit 2003-09-10 15:04:26 UTC
fs->oj: If we really do this, then it's most probably up to you ...
Comment 3 hans_werner67 2004-02-02 12:17:46 UTC
change subcomponent to 'none'
Comment 4 marc.neumann 2004-04-28 12:48:26 UTC

according to
retarget to OOo_Later

Bye Marc