Symphony.

I have made some comparisons between Symphony 2.0.6 and 2.0.7 RC2. It looks like the number of database queries has been reduced strongly. But I wonder why datasource execution times have not – indeed they are a little bit higher than before. Here is a typical comparison for a section “haendler” using a Select Box Link to “marken” (which used to generate lots of queries, as you can see):

Symphony 2.0.6:      marken    0.0709 s from 229 queries
                     haendler  0.6524 s from 1659 queries
Symphony 2.0.7 RC2:  marken    0.0375 s from 60 queries
                     haendler  0.8041 s from 75 queries

Any ideas why this is the case?

Actually the case above might be somewhat special. Here’s another (rather complicated) page:

2.0.6:
marken                     0.0927 s from 229 queries
navigation_produktgruppen  0.0308 s from 95 queries
produktgruppe              0.0073 s from 21 queries
navigation                 0.0094 s from 37 queries
produkt                    0.0133 s from 45 queries
produkt_galeriebilder      0.1479 s from 426 queries
produkte                   0.1309 s from 370 queries
produkte_archiv_flag       0.0059 s from 10 queries
                           --------
                           0.4382 s

2.0.7 RC2:
marken                     0.0376 s from 61 queries
navigation_produktgruppen  0.0181 s from 23 queries
produktgruppe              0.0062 s from 8 queries
navigation                 0.0103 s from 37 queries
produkt                    0.0026 s from 1 query
produkt_galeriebilder      0.0024 s from 1 query
produkte                   0.0978 s from 61 queries
produkte_archiv_flag       0.0039 s from 1 query
                           --------
                           0.1789 s

The time running all datasources has been reduced significantly here. Cool.

Nick’s datasource improvements mainly, you can read about them here

I’m not sure evey Data Source will have improved but I’m glad you’re seeing improvements. The DS that pulls from a section using a Select Box Link, have you tried ticking/unticking the new checkbox at the bottom of the DS Editor which toggles the “count of related entries” attribute added to the <entry> elements? This can save significant queries too, if your section uses many SBLs.

have you tried ticking/unticking the new checkbox at the bottom of the DS Editor which toggles the “count of related entries” attribute

Indeed. The number of queries has been reduced even more! And the time to execute the DSs is another “20 percent off”. Very cool.