https://bugs.documentfoundation.org/show_bug.cgi?id=90780
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW Ever confirmed|0 |1 OS|Windows (All) |All --- Comment #11 from [email protected] --- Have had time to figure out how to start the logging. Simple by typing this SQL-command as admin: SET GLOBAL general_log = 'ON'; Notice: All what I have tested I tested with MariaDB and no other client connecting to MariaDB. I notice 1) for every row a new query is started like this one: SELECT * FROM "libretest"."Test" WHERE "libretest"."Test"."ID" = 11099 2) setting the table to last row only the last shown rows where queried 3) scrolling up from the last row it shows queries for the upper rows, but I notice also queries for the last rows (as noticed in (2)) every time I stop scrolling up. Don't know why the last rows are queried again and again. Looking at the table scrolling will hang a little bit with (3). I could send a query from Base through Tools → SQL - it is only one query for all data I'm looking for: SELECT * FROM "libretest"."Test" WHERE "libretest"."Test"."ID" < 100 shows all data in Tools - SQL and doesn't need more queries than only one. Don't know why the GUI is designed this way. If there are many queries from other clients it must be a performance-problem for MySQL. I will set this bug to new. Changed also the system to all, because I have tested with OpenSUSE. LO-Version here is 4.3.7.2 -- 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
