https://bugs.documentfoundation.org/show_bug.cgi?id=90780
--- Comment #15 from Robert Großkopf <[email protected]> --- Bug is still the same with LO 7.3.0.3 There are many queries if scrolling through a table with primary keys. Every key-value will be logged as a separate query. If the primary key will be changed to UNIQUE or the whole table should be shown as view there won't be executed many queries while scrolling. The tested performance with primary key on http://linux-blog.anracom.com/2013/11/22/mariadb-mysql-libreoffice-4-x-konnektoren-performance-problem-wegen-primary-keys/ will give a difference from 4:40 minutes in LibreOffice with Calc and table in the database browser to 8 seconds in MSExcel. If there isn't a primary key the Calc will load the tables in database browser as fast as MSExel did. All this is tested 2013, but it shows the problem and the real behavior with many queries for every row hasn't been changed in LO. -- You are receiving this mail because: You are the assignee for the bug.
