Hi,

I’ve been testing Publisher for a multilingual site I might develop and I’m totally impressed by the possibilities it provides! Well, except for one thing..
When logged in as a Super Admin the CP crawls literally making the back-end administration not possible.
I watched the Output Profiler and realized that Publisher is making countless sql queries for each custom field on each CP page load, even if not (at least obviously) required for that specific CP page..
I’m talking about 350+ queries just to load the CP Home.
When I try to edit a custom field it does over 650!

The specific site is a demo one to showcase to a client as a proof of concept with 24 channels consisting of almost 300 custom fields.
Yes, I know that it probably should be re-modeled and optimized but that doesn’t justify the number of queries and specifically for pages that shouldn’t require these Publisher data to be loaded from the db.
And in addition to that, why the CP works fine for non-Super Admins?

When I login as a non-SuperAdmin user everything works great. Even with user accounts that belong to a full-privilleged membergroup based on SuperAdmins.
When you publish on a channel with a myriad custom fields it takes about 60-80 queries and 4-8 secs to load the edit screen but this is totally accepted.
As a Super Admin, the same page takes more than 400 queries and 25-40 secs to load.

Another thing I noticed is that even though the script execution time (at the CP footer) is about 8 secs for an average CP page, the actual page needs more than 15 additional secs to be fully loaded.
This is pointing me to some js/css loading bottleneck.
And again, this is happening only for Super Admins.

I should also mention that there are many other 3rd party addons installed that may interfere with Publisher (especially on the js/css loading domain) but while trying to debug this problematic behavior, everything is pointing to Publisher doing unnecessary stuff behind the scenes.
I tried disabling many of them and even though the speed of the CP was improved, when I temporarily disabled Publisher every question came to a closure. The CP got breathing again and page loading times were very fast (like I was not logged in as a Super Admin).

What does Publisher do when you are logged in a as a Super Admin that doesn’t on all other membergroups (even on membergroups with full privilleges)?

Thanks in advance