[Libreoffice-bugs] [Bug 118094] Firebird: Support more XResultSet functions

[bugzilla-daemon at bugs.documentfoundation.org]

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

Drew Jensen <drewjensen.inbox at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|normal                      |enhancement

--- Comment #11 from Drew Jensen <drewjensen.inbox at gmail.com> ---
Great. Changed the setting on the issue.

Allowing xRowSet function calls against Statement (XResultSet) would be an
example, yes.

One thing that crosses my mind, just as an observer of late. 

As I do some comparison between Base files with identical structures (hsql vs
firebird) is how much more responsive the forms (using queries) are not only in
the firebird files but against the large hsql files. Some of the other
components in Base do not seem to have changed (still dog slow in the HSQL
file) but in forms displaying relatively short result sets (with multiple
joins) HSQL is actually just a tad faster IT FEELS LIKE then the firebird
engine. (maybe me smile and laugh a bit) [then there is startup and shutdown of
the engine and that's where the HSQL file is a major problem and firebird is
plenty snappy]

Which is all to say that if having to use one more line of basic, to explicitly
get a xrowset from a result, so as to use some of the positioning functions of
a rowset vs resultset is the price of making the form/sub_form functioning
faster, that would be a worthwhile trade off in my mind.

-- 
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/20180610/f35a95bd/attachment.html>