Issue 15202

Summary: [RFE] allow faster deletion of table data
Product: Base Reporter: Frank Schönheit <frank.schoenheit>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 1.1 Beta2   
Target Milestone: ---   
Hardware: PC   
OS: Windows 2000   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

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
Hi,

according to http://development.openoffice.org/releases/Target_Milestone.html
retarget to OOo_Later

Bye Marc