Sims Connect.ini CommandTimeout

[sunny88]

Hi.

Is there a magic number for the commantimeouts. We have an issue where pupil details takes a long time to load. the rest of sims is Fine.

currently i have comandtimeout=1000000 in the connect.ini.

Is there a better number to use to speed this up.

[PotNoodleTech]

The timeout number is just hiding the problem of why is it taking so long to load the data, that it times out - investigate why the database is slow.

[sunny88]

The timeout number is just hiding the problem of why is it taking so long to load the data, that it times out - investigate why the database is slow.

 

We have, so i have run reindex patches, the server has 18gb of ram, SQL has enough assigned to it. Before reports were slow when SQL was set in SQL compatibility Mode to 2012.

Since then i set it to 2022 and sims loads up in 10 secs and reports are fast. But we cannot get pupil details to be fast. This takes about 6 seconds which the school say is slow. Database diagnostics did show some pupils missing surnames etc.

[PotNoodleTech]

If your talking about loading the whole school by using edit marks then that will always be slower as it's loading many hundreds of records at once.

[sunny88]

If your talking about loading the whole school by using edit marks then that will always be slower as it's loading many hundreds of records at once.

 

Im talking searching for pupil records. so focus - pupil details

[PotNoodleTech]

Im talking searching for pupil records. so focus - pupil details

 

ok came up in 1 second for me even searching for a popular surname returning 38 rows?

[sunny88]

ok came up in 1 second for me even searching for a popular surname returning 38 rows?

 

onger for this school. what SQL and Server OS are you running

[PotNoodleTech]

onger for this school. what SQL and Server OS are you running

 

This is on SIMS connected so ESS's cloud SQL servers.