https://bugs.freedesktop.org/show_bug.cgi?id=81541
Lionel Elie Mamane <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|[email protected] |[email protected] | |desktop.org --- Comment #13 from Lionel Elie Mamane <[email protected]> --- (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. -- 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
