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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #2 from Drew Jensen <drewjensen.inbox at gmail.com> ---
(In reply to robert from comment #1)
> What do you get when switching to direct SQL?
> Have tested this with the new BaseDocumenter. 

bingo, that is an excellent databases as an example. 

BTW; In that particular case it gets worse, for me here anyways, when the
database is moved into firebird; once converted the 6.2 builds are worse
performance than the 6.1 and prior releases. IN fact it got worse of late: with
the lastest build: Opening the 'objects' table triggers multiple screen updates
in the Table View window and have ended up killing Libreoffice because it never
seems to finish *IF* I try to scroll the tablecontrol. (I didn't try the HSQL
version of the file today)

> .... Opening a table ("OBJECTS") is
> very slow (16GB Memory, I5-Pozessor). But there is the same result when
> starting the query in Tools > SQL: SELECT * FROM "OBJECTS". Last a long time
> to show the result.

The delay does not appear to be in the creation of the result set, which you
can see if you base a form off the query definition.  The new form wizard for
instance does not include CLOB fields  in a tablecontrol by default, you can of
course use a add a sub-form in the wizard based on the same querydef and put
the first of the CLOB fields on the form. In this configuration, even if you
add two more text controls for the other two CLOB fields, the form will open up
quick as can be and the tablecontrol is not delayed in any way as you scroll
through it. The text controls change contents as you do.

It appears the real problem is with how the table control is pulling data for
the clob fields when configured to display them.

The RFE here is to refactor the tablecontrol to address the performance when
CLOB fields are included. (there could be a sister issue about BLOB fields, but
seemed better to keep them separate)

-- 
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/3d73220a/attachment-0001.html>