The check validation before sync is slow


#1

I updated owncloud from 9.1.4 to 10.0.0, I mantained server resources and desktop client 2.3.1 (windows) and now the check before the sync (upload/download file) is slow, very slow than 9.1.4 version, How do I resolve this?

I add information: the DB is 8Gb...

thanks


#2

Without more info it is hard to help.

Could you check your HTTP access.log and check the time stamps between the PROPFIND calls when a sync is running? Do those calls take a long time?


#3

this is the access_log of the last rows:

192.168.1.115 - rossana.foti [07/Jun/2017:14:10:56 +0200] "PROPFIND /remote.php/dav/files/rossana.foti/SF243_15/SF243_15-C05-DESIGN/C05.02%20EXECUTIVE%20PROJECT HTTP/1.1" 207 846
5.133.56.102 - cinzia.cara [07/Jun/2017:14:10:56 +0200] "PROPFIND /remote.php/dav/files/cinzia.cara/SF171_09%20(2)/SF171_09-C11-SERVER%20LOCALE%20MILANO/Cartella%20per%20PERSEGHIN%20C171/C%2011%20-%20Corrispondenza/11.02%20-%20Posta%20in%20uscita/11.02.14%20-%20Sub/Novate%20Mineraria HTTP/1.1" 207 4170
192.168.1.79 - luigi.tuzi [07/Jun/2017:14:10:56 +0200] "PROPFIND /remote.php/dav/files/luigi.tuzi/SF243_19-RM_2016%20(2)%20(2)/SF243_19-RM_2016-C07-QUALITY/C07.03-TEST%20REPORTS HTTP/1.1" 207 866
192.168.1.111 - tiziano.tolli [07/Jun/2017:14:10:56 +0200] "PROPFIND /remote.php/webdav/SF199_11/2013/Prior%2042/C%2002%20-%20Studio%20Gara/02.01%20Budget HTTP/1.1" 207 712
192.168.1.128 - marco.straccamore [07/Jun/2017:14:10:56 +0200] "PROPFIND /remote.php/dav/files/marco.straccamore/SF243_15/FI/SF243_260-FI_2017/SF243_260-FI_2017-C12-RDA HTTP/1.1" 207 849
192.168.1.174 - silvano.grossi [07/Jun/2017:14:10:56 +0200] "PROPFIND /remote.php/webdav/SF245_15/BA/SF245_02-BA/SF245_02-BA-C11-ACCOUNTING HTTP/1.1" 207 1284
192.168.1.149 - alessandro.dipaolo [07/Jun/2017:14:10:56 +0200] "PROPFIND /remote.php/webdav/SF219_12/SF219_12-C08-ENVIRONMENT/C08.02-ENVIRONMENTAL%20MONITORING/Dossier%20ambiente/03_PCA%20operativi/23_PCA%20settembre%202015 HTTP/1.1" 207 2092
192.168.1.82 - giuseppe.deluca [07/Jun/2017:14:10:56 +0200] "PROPFIND /remote.php/webdav/SF241_14/FI/SF241_17-FI_2016/SF241_17-FI_2016-C06-SERV.%20AND%20SUP/C06.08-SERVICES/09%20-%20Sirit_distacco%20posa%20cavo%20IS%20(3)/04%20-%20Contabilit%C3%A0 HTTP/1.1" 207 804
176.246.37.56 - antonio.acunzo [07/Jun/2017:14:10:57 +0200] "PROPFIND /remote.php/webdav/SF244_15/PA/SF244_03-PA_2016/SF244_03-PA_2016-C04-CONTR.MANAG/C04.01-WORK.PROGR.STATES HTTP/1.1" 207 5289
192.168.1.139 - paolo.giuliani [07/Jun/2017:14:10:57 +0200] "PROPFIND /remote.php/webdav/SF255_15%20(2)/AN/SF255_05-AN_2016/SF255_05-AN_2016-C06-SERV.%20AND%20SUP/C06.03-SUBCONTRACTING/SO.CO.EL/02-Documenti/Doc.%20SOCOEL/DOCUMENTO%20SUBAPPALTO%20SOCOEL%20255%205%20AN HTTP/1.1" 207 1536
192.168.1.115 - rossana.foti [07/Jun/2017:14:10:57 +0200] "PROPFIND /remote.php/dav/files/rossana.foti/SF243_15/SF243_15-C05-DESIGN/C05.03-CONSTRUCTION%20PROJECT HTTP/1.1" 207 847
192.168.1.111 - tiziano.tolli [07/Jun/2017:14:10:57 +0200] "PROPFIND /remote.php/webdav/SF199_11/2013/Prior%2042/C%2002%20-%20Studio%20Gara/02.02%20Fornitori HTTP/1.1" 207 715
192.168.1.79 - luigi.tuzi [07/Jun/2017:14:10:57 +0200] "PROPFIND /remote.php/dav/files/luigi.tuzi/SF243_19-RM_2016%20(2)%20(2)/SF243_19-RM_2016-C07-QUALITY/C07.04-METHOD%20STATEMENT HTTP/1.1" 207 870
192.168.1.88 - massimo.pratico [07/Jun/2017:14:10:57 +0200] "PROPFIND /remote.php/webdav/SF242_15/SF242_15-C06-SERV.%20AND%20SUP/C06.01-SUPPLIES/C06.01.24%20BIAGIOTTI_chiusini%20zincati/01%20-%20Contratto HTTP/1.1" 207 4936
192.168.1.174 - silvano.grossi [07/Jun/2017:14:10:57 +0200] "PROPFIND /remote.php/webdav/SF245_15/BA/SF245_02-BA/SF245_02-BA-C11-ACCOUNTING/C11.01-PURCHASE%20INVOICES HTTP/1.1" 207 723
5.133.56.102 - cinzia.cara [07/Jun/2017:14:10:57 +0200] "PROPFIND /remote.php/dav/files/cinzia.cara/SF171_09%20(2)/SF171_09-C11-SERVER%20LOCALE%20MILANO/Cartella%20per%20PERSEGHIN%20C171/C%2011%20-%20Corrispondenza/11.02%20-%20Posta%20in%20uscita/11.02.14%20-%20Sub/Nuove%20Strade%20Srl HTTP/1.1" 207 3401
192.168.1.128 - marco.straccamore [07/Jun/2017:14:10:57 +0200] "PROPFIND /remote.php/dav/files/marco.straccamore/SF243_15/FI/SF243_270-FI_2017 HTTP/1.1" 207 9342
192.168.1.149 - alessandro.dipaolo [07/Jun/2017:14:10:57 +0200] "PROPFIND /remote.php/webdav/SF219_12/SF219_12-C08-ENVIRONMENT/C08.02-ENVIRONMENTAL%20MONITORING/Dossier%20ambiente/03_PCA%20operativi/23_PCA%20settembre%202015/01_Campiglia HTTP/1.1" 207 1503
192.168.1.139 - paolo.giuliani [07/Jun/2017:14:10:57 +0200] "PROPFIND /remote.php/webdav/SF255_15%20(2)/AN/SF255_05-AN_2016/SF255_05-AN_2016-C06-SERV.%20AND%20SUP/C06.03-SUBCONTRACTING/SO.CO.EL/02-Documenti/Doc.%20SOCOEL/DOCUMENTO%20SUBAPPALTO%20SOCOEL%20255%205%20AN/DOCUMENTO%20SUBAPPALTO HTTP/1.1" 207 13286
192.168.1.82 - giuseppe.deluca [07/Jun/2017:14:10:57 +0200] "PROPFIND /remote.php/webdav/SF241_14/FI/SF241_17-FI_2016/SF241_17-FI_2016-C06-SERV.%20AND%20SUP/C06.08-SERVICES/10%20-%20Sirit_distacco%20posa%20cavo%20IS%20(4) HTTP/1.1" 207 3429
192.168.1.115 - rossana.foti [07/Jun/2017:14:10:57 +0200] "PROPFIND /remote.php/dav/files/rossana.foti/SF243_15/SF243_15-C05-DESIGN/C05.04-AS%20BUILT HTTP/1.1" 207 835
192.168.1.79 - luigi.tuzi [07/Jun/2017:14:10:57 +0200] "PROPFIND /remote.php/dav/files/luigi.tuzi/ HTTP/1.1" 207 483
176.246.37.56 - antonio.acunzo [07/Jun/2017:14:10:57 +0200] "PROPFIND /remote.php/webdav/SF244_15/PA/SF244_03-PA_2016/SF244_03-PA_2016-C04-CONTR.MANAG/C04.01-WORK.PROGR.STATES/5)%20SAL2%20Feb17%20Contesse%20Esperia-Salcef-Rfi HTTP/1.1" 207 4393
192.168.1.111 - tiziano.tolli [07/Jun/2017:14:10:57 +0200] "PROPFIND /remote.php/webdav/SF199_11/2013/Prior%2042/C%2003%20-%20Documentazione%20contrattuale HTTP/1.1" 207 3133
192.168.1.174 - silvano.grossi [07/Jun/2017:14:10:57 +0200] "PROPFIND /remote.php/webdav/SF245_15/BA/SF245_02-BA/SF245_02-BA-C12-RDA HTTP/1.1" 207 689
192.168.1.88 - massimo.pratico [07/Jun/2017:14:10:57 +0200] "PROPFIND /remote.php/webdav/SF242_15/SF242_15-C06-SERV.%20AND%20SUP/C06.01-SUPPLIES/C06.01.25%20BIAGIOTTI_lamiera%20-%20tirafondi HTTP/1.1" 207 2790
192.168.1.139 - paolo.giuliani [07/Jun/2017:14:10:57 +0200] "PROPFIND /remote.php/webdav/SF255_15%20(2)/AN/SF255_05-AN_2016/SF255_05-AN_2016-C06-SERV.%20AND%20SUP/C06.03-SUBCONTRACTING/SO.CO.EL/03-Varie HTTP/1.1" 207 1462
192.168.1.79 - luigi.tuzi [07/Jun/2017:14:10:57 +0200] "PROPFIND /remote.php/dav/files/luigi.tuzi/SF243_19-RM_2016%20(2)%20(2)/SF243_19-RM_2016-C07-QUALITY/Grafici%20Rincalzatrice HTTP/1.1" 207 7263
192.168.1.128 - marco.straccamore [07/Jun/2017:14:10:57 +0200] "PROPFIND /remote.php/dav/files/marco.straccamore/SF243_15/FI/SF243_270-FI_2017/SF243_270-FI_2017-C01-TENDER%20DOC HTTP/1.1" 207 3338
192.168.1.149 - alessandro.dipaolo [07/Jun/2017:14:10:57 +0200] "PROPFIND /remote.php/webdav/SF219_12/SF219_12-C08-ENVIRONMENT/C08.02-ENVIRONMENTAL%20MONITORING/Dossier%20ambiente/03_PCA%20operativi/23_PCA%20settembre%202015/02_Roma%20Aurelia HTTP/1.1" 207 1518
5.133.56.102 - cinzia.cara [07/Jun/2017:14:10:57 +0200] "PROPFIND /remote.php/dav/files/cinzia.cara/SF171_09%20(2)/SF171_09-C11-SERVER%20LOCALE%20MILANO/Cartella%20per%20PERSEGHIN%20C171/C%2011%20-%20Corrispondenza/11.02%20-%20Posta%20in%20uscita/11.02.14%20-%20Sub/Omarini HTTP/1.1" 207 2501