https://bugs.documentfoundation.org/show_bug.cgi?id=90780
--- Comment #4 from [email protected] --- (In reply to Alex Thurgood from comment #2) > I suppose one must always ask the question how much extra latency gets added > through the use of a SSH tunnel to connect to the mysql instance. How do you > set this up ? - port forwarding ? or direct SSH connection ? I did 2 tests: over SSH tunnel and direct (non SSL) connection. There is no noticeable difference. Moreover I tested with MySQL Workbench and Access 2013 over SSH tunnel – both work very fast. Tested with different connectors (see first comment). The server has a 1 Gbit/s bandwidth. I (the client) have 50 Mbit/s VDSL bandwidth. Ping is < 35 ms. I have checked the system resource no noticeable high workload on CPU, RAM, SSD and ethernet on both server and client. The MySQL log shows many selects while scrolling the data grid table: 588 Execute SELECT * FROM "prosodia"."titles" WHERE "prosodia"."titles"."id" = 76 588 Execute SELECT * FROM "prosodia"."titles" WHERE "prosodia"."titles"."id" = 77 588 Execute SELECT * FROM "prosodia"."titles" WHERE "prosodia"."titles"."id" = 78 … If I leave the primary key `id`, I get one select in the log only: 150422 22:37:44 588 Prepare SELECT "name" FROM "prosodia"."titles" AS "titles" WHERE ( 0 = 1 ) 588 Close stmt 588 Prepare SELECT "name" FROM "prosodia"."titles" AS "titles" WHERE ( 0 = 1 ) 588 Close stmt 588 Prepare SELECT "name" FROM "prosodia"."titles" AS "titles" 588 Execute SELECT "name" FROM "prosodia"."titles" AS "titles" (scrolling the data grid up and down like crazy; works fast) -- 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
