Slow item form saving on big site with relation field

Hello

finally, the next thing to do in the evening is re-test this case

Hello

ok, biggest part is the Joomla Smart Search Index update (updating is very slow on large sites)
- i have disabled the CONTE PLUGIN "finder" in your website (since you do not use it) ,
this greatly reduces the time needed to save the form

please save a form a few times to test

- now out of the remaing time then the relation field is now a considerable ... delay but tolerable ... it needs to be optimized

[EDIT]
the above was done in the testing web-site ...

Hello

besides improving 3 things:
- small JS validation delay on submit
- AJAXifying the relation field
- AJAXifying the layout parameters loading

i found a very slow query too ... which i think it was the main delay
- SQL query duplicate alias check ...
you can see the issue in the Joomla issue tracker:

github.com/joomla/joomla-cms/issues/10567

i guess fix will be in Joomla 3.6.0

But i have made a fix / workaround for FLEXIcontent regardless of Joomla version

- Final results for your website (after all changes in FLEXIcontent v3.0.15)
(my localhost with DataBase on SSD drive)

1 sec FORM Save + 1 seco FORM load (create) time
+ (0.5 second for browser to render the page)

Thanks for your help. Can I somewhere download the flexicontent 3.15?

Hello

Download v3.0.15-dev from (click download zip):
github.com/FLEXIcontent/flexicontent-cck/tree/3.0.x-stable

then install via Joomla extension manager in a testing / copy site