https://bugs.freedesktop.org/show_bug.cgi?id=81541
--- Comment #14 from Marino Capriotti <[email protected]> --- (In reply to comment #13) > (In reply to comment #12) > > @Lionel - I don't think I experienced it quite like you said when I > > duplicated the bug: > > > > 1. Searching the one without the ID it was indeed slow first, and then fast > > Yes, you experience the same than I do. > > > 2. Searching with ID - it was never fast, not the first, nor the last time I > > tested. > > Yes, you experience the same than I do. > > Essentially, retrieving the data is what is slow (because JDBC / bug 57872). > Without primary key, LibreOffice retrieves the data only once. With primary > key, LibreOffice trusts it can get the data again and thus caches only a few > dozens of rows. Because LibreOffice fetches the whole data to search > (instead of having the search done by the database, that's bug 44954), > search in a JDBC database (with primary key) is horribly slow. > > "Fixing" either of these bugs would make this particular scenario a > non-issue. Hi Lionel "Fixing" doesn't seem to be much of a priority since both bugs are quite old harking back as they do to 3.x versions. Any workaround before I'm forced to give up? Thanks! -- 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
