db-slow 6.9412 secondi select * from fnbl_simple_calendar_imp

[MassimoA]

Hello,
when i go to the calendar the system show it after some seconds (too much time).

In the events panel i can see two warnings, a db-slow and a system-slow:

9.37 secondi index.php?folder=5701

*** | 9:56 | #25472319

Id	25472319
Creato	9:56
Server	***
Server-IP	***
Username	***
Componenti	system-slow
Messaggio	9.37 secondi index.php?folder=5701
Traccia	/sgs/bin/index.php?folder=5701

7.1339 secondi select * from fnbl_simple_calendar_imp where userid='***' and lastmodified > '1451550199'

*** | 9:56 | #25472419

Id	25472419
Creato	9:56
Server	***
Server-IP	***
Username	***
Componenti	db-slow
Messaggio	7.1339 secondi select * from fnbl_simple_calendar_imp where userid='***' and lastmodified > '1451550199'
Traccia	#0 /var/www/html/sgs/bin/core/functions.php(1175): sys_backtrace()<br />#1 /var/www/html/sgs/bin/core/classes/sync4j.php(150): db_select('fnbl_simple_cal...', '*', Array, '', '', Array)<br />#2 /var/www/html/sgs/bin/core/functions.php(347): sync4j::import_createedit('5701', 'calendar', '***', '1451550799', Array)<br />#3 /var/www/html/sgs/bin/core/functions.php(387): _asset_process_syncml_requests()<br />#4 /var/www/html/sgs/bin/index.php(84): asset_process_session_request()<br />#5 {main} '1 PRIMARY <derived2> ALL    14030 Using where<br />2 DERIVED fnbl_pim_calendar ALL    14401 Using where<br />3 DEPENDENT SUBQUERY fnbl_pim_calendar_exception ref PRIMARY PRIMARY 8 ***.fnbl_pim_calendar.id 1 Using index<br />'

In yours systems it use so much seconds to show the calendar?
Do you have a solution to resolve it?

Best regards
Massimo

[Patrick Pliessnig]

Hi Massimo

Works fine with me.
NO db-slow in a calendar folder with over 600 assets.

Have you executed standard maintenance tasks with sgs and maybe restarted the db?

happy new year
Patrick

[Massimo Arnaudo]

Hi Patrick,

happy new year!

What you mean for maintenance tasks?

I Usually exec those commands:

http://<myip>/sgs/bin/index.php?folder2=3901&view2=display&action_sys=clean_cache
http://<myip>/sgs/bin/index.php?folder2=3901&view2=display&action_sys=clean_tables
http://<myip>/sgs/bin/index.php?folder2=3901&view2=display&action_sys=rebuild_search&token=924feff8f4777c1bbdbdd9f639728a04

The last process usually show this error:
Id –

25479819

 Creato 

12:54

 Server 

...

 Server-IP 

...

 Username 

...

 Componenti 

php-fail

 Messaggio 

Php Notice: 04/01/16 12:54:42 pm Undefined offset: 0 /var/www/html/sgs/bin/core/functions.php 919

 Traccia 

1. #0 /var/www/html/sgs/bin/core/functions.php(1315): sys_backtrace()<br />#1 /var/www/html/sgs/bin/core/functions.php(919): debug_handler(8, 'Undefined offse...', '/var/www/html/s...', 919, Array)<br />#2 /var/www/html/sgs/bin/core/classes/admin.php(246): db_get_schema('../custom//modu...', '', '', false)<br />#3 /var/www/html/sgs/bin/core/classes/admin.php(188): admin::rebuild_schema(true)<br />#4 /var/www/html/sgs/bin/core/functions.php(2960): admin::process_action_sys()<br />#5 /var/www/html/sgs/bin/index.php(77): sys_process_session_request()<br />#6 {main}<br />$_REQUEST: Array<br />(<br />    [folder2] => 3901<br />    [view2] => display<br />    [action_sys] => rebuild_search<br />    [token] => 779c963ddbca87801591bd2036c4dc14<br />    [folder] => 3901<br />    [view] => display<br />)<br />

Now the system is faster when i go tho the calendar folder, but the db-slow always appear:

25600519

13:32

<myip>

<myuser>

db-slow

1.5100 secondi select * from fnbl_simple_calendar_imp where userid='user' and lastmodified > '1451907059'

Any idea to resolve completely?
Massimo

--
You received this message because you are subscribed to the Google Groups "Simple Groupware" group.
To unsubscribe from this group and stop receiving emails from it, send an email to simple-groupwa...@googlegroups.com.
To post to this group, send email to simple-g...@googlegroups.com.
Visit this group at https://groups.google.com/group/simple-groupware.
For more options, visit https://groups.google.com/d/optout.

[Massimo Arnaudo]

Hello,
as I have not found the solution for this slowness, I took the opportunity to create a new server on which to host SGS, inside a VPN network and using the RDS service of AWS.

Now it works great!

Massimo

[Patrick Pliessnig]

:-)