[Libreoffice-bugs] [Bug 119386] New: current table grid control performance is unacceptable in the Table View and Query View implementation when result set includes CLOB fields when text data exceeds 64K

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=119386

            Bug ID: 119386
           Summary: current table grid control performance is unacceptable
                    in the Table View and Query View implementation when
                    result set includes CLOB fields when text data exceeds
                    64K
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: drewjensen.inbox at gmail.com

Description:
The current implementation of the grid control takes a large performance hit
when the underlying result set includes multiple CLOB fields and the fields
hold in excess of 64K worth of text. 

This is not backend specific, it is a problem whether an embedded data engine
(hsql, firebird) or external (mysql, postgress)

The problem does not happen for individual data controls on forms.

The problem can be mediated in the Table View by hiding the CLOB fields at run
time.

Waiting on word back from a DB owner about using this data as an attachment -
if I don't get that by this afternoon will gin up some test data separately and
attach that.




Steps to Reproduce:
1. Open any ODB attached to a datasource which includes a table including
multiple clob fields (firebird) or memo fields (hsql) for instance.
2. Go to the Tables section
3. Open the table with the CLOB fields
4. Try to move through the table my scrolling.

Actual Results:
With a test file here of only 20 records, but all 20 records holding 100K text
loads in three clob fields the performance comes to a grind. 

Expected Results:
The table view should scroll without undue delays. 


Reproducible: Always


User Profile Reset: No



Additional Info:
The current grid control, and all data controls, can only display the first 64K
of text and I think the data being greater that that may trigger some error
handling as the root of the problem here, but that is just a guess on my part.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180820/c055d8a1/attachment.html>