Slow item form saving on big site with relation field

Dear,

We have a large flexicontent site (+10000 articles). We have about 20 flexicontent types with each about 100 custom fields. One field is a related items field. Some articles have a lot of references to other articles.
A basic new item takes about 13 sec to save with no fields filled in. If starting adding a lot of related items (+100 links), then the saving of an article can goes up to +1 minute. Is this behaviour normal? Can we optimize settings? I have run the mysql queries directly on the database and this is very fast (0.0017 sec). We don't think mysql is the issue.

Thanks for the help in advance

FLEXIcontent version ?
Joomla version ?
Serveur config ?
regards

Hello

Item form saving
1- clears some shared cache data,
2- and it updates indexes
3- it is effected by number of templates
4- relation field is download and looping ALL allowed items

1. is optimized in v3.013 / v3.014
2. was optimized in v3.0.x

3. it starts to become an issue, if you have 40+ flexicontent templates

4. the problem in your site is the relation field, it is probably 80%-95% of the time spent
(especially in item form loading)

relation field is set to be updated and optimized in v3.1 ....

joomla 3.4.8
flexicontent version 3.0.13
Server config: VM 8 Gb Ram, 12 cores, SSD disk

Hello

you may send me a PM with admin access to review this

there may be other things in effect

I have send you a PM with a user.

Hello

it is not relation field, it is indeed slow about 1.5 - 2 seconds on form load

In my test i found
16 seconds to submit/save
then
4 seconds to load the form

- the form loading is large 4 seconds due to relation field, but form saving (16 seconds) is too slow
- maybe some installed content or system plugins ?
i will test soon

Dear,

Do you already have an idea which components is causing this slow save? Many thanks for your help.

Kind regards

Hello

i will test locally please remind if you don't get answer by tomorrow evening (UTC+0 time)

as i said i did spend some time to test,

but i need to spend more on this , i am not sure yet where this time is spent, but i did confirm that relation field only adds a portion of the delay:
2 - 2,5 seconds (which is what i had expected for the size of your site, and considering it is loading all items ids and titles)

Test locally is needed
(i think i have asked you permission to copy site to do this otherwise it will be very difficult test (because you have several 3rd party extensions) and i would not spend that time on online site to do it)

You have the GO from me to install the site locally.

Thanks for the help