https://bugs.freedesktop.org/show_bug.cgi?id=51976
Lionel Elie Mamane <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |WONTFIX See Also| |https://bugs.freedesktop.or | |g/show_bug.cgi?id=57872, | |https://bugs.freedesktop.or | |g/show_bug.cgi?id=52170, | |https://bugs.freedesktop.or | |g/show_bug.cgi?id=53281 --- Comment #27 from Lionel Elie Mamane <[email protected]> --- (In reply to comment #17) > There is clearly a loss of performance between 3.4.5 and 3.4.6. > My guess is that the culprit is > http://cgit.freedesktop.org/libreoffice/core/commit/ > ?id=3623701d65f92017da905f4debf5514045f502c8 > made to fix bug 44813. HSDQLDB 1.8 probably just has lousy performance on my > hackish query... Looks like I'll have to make that query dynamic after all. During the hackfest, I made that query dynamic. One then wins about 20 to 30% on HSQLDB, but will potentially lose performance on other database engines that have better query optimisation engines: we exchange more calls to SQLPrepare() or some such for a query that is easier to optimise for the database. I decided not to punish, but rather reward, database engines with good query optimisation, and will thus leave this particular bug (which was *only* about the performance loss introduced by the above commit) as it is. For *other* performance issues with embedded HSQLDB and/or JDBC in general, see bug 52170 and/or bug 57872. Will attach the patch to make the query dynamic for archiving. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
