Slow item form saving on big site with relation field

arc3c
Topic Author
Offline
Senior Member

8 years 7 months ago - 8 years 7 months ago #60718 by arc3c

Slow item form saving on big site with relation field was created by arc3c

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

Last edit: 8 years 7 months ago by ggppdk.

Please Log in or Create an account to join the conversation.

micker
Offline
Administrator

8 years 7 months ago - 8 years 7 months ago #60719 by micker

Replied by micker on topic Slow item form saving on big site with relation field

FLEXIcontent version ?
Joomla version ?
Serveur config ?
regards

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Last edit: 8 years 7 months ago by ggppdk.

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

8 years 7 months ago - 8 years 7 months ago #60721 by ggppdk

Replied by ggppdk on topic Slow item form saving on big site with relation field

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 ....

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Last edit: 8 years 7 months ago by ggppdk.

Please Log in or Create an account to join the conversation.