https://bugs.documentfoundation.org/show_bug.cgi?id=90780
--- Comment #9 from [email protected] --- (In reply to ronny from comment #8) > Thanks for your tests. Have you looked the queries shown in mysql.log? > (config: general_log_file = /var/log/mysql/mysql.log; general_log = 1). Did > you get many entries like 588 Execute SELECT * FROM "prosodia"."titles" > WHERE "prosodia"."titles"."id" = 1 if you scroll the tables? LO seems to > query each primary key (in my case id) separately. > > Can LO log the queries that it sends to MySQL? I don't find a log-file at this place for the query-logs. So I started phpMyAdmin. Switching from row 1 to row 11.125 gets 117 selects. Seems the cache is filled with about 100 rows for each select. Then I tried to move by the mouse. There I got 4180 selects and moved only from row 1 to 3664 ... The traffic is very high this time. Seems I could not reproduce the performance-bug, because I'm the only user of the database. Don't know why there are 4180 selects for only 3664 rows. -- 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
