Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||[RFE] allow faster deletion of table data|
|Product:||Base||Reporter:||Frank Schönheit <frank.schoenheit>|
|Component:||code||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Version:||OOo 1.1 Beta2|
|Issue Type:||ENHANCEMENT||Latest Confirmation in:||---|
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