<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - 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"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=119386">119386</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>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
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>Inherited From OOo
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>enhancement
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>drewjensen.inbox@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>