Slow item form saving on big site with relation field

2 years 6 months ago #61914 by arc3c
Dear,

Do you have already some more info?

Thanks for the help.

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

2 years 6 months ago - 2 years 6 months ago #61925 by ggppdk
Hello

for start we did optimize our JS validation code even more for very big forms ! (will be in v3.0.15) (in your case you will see some small benefit by it)

- your case is still in the short term todo (of retrying, sorry was on vacations (Easter) so only had time to look at bug reports and features needing little code)

You do well to post reminder (more than once) answering all forum messages is sometimes a lot of work
- there will be higher priority support for "subscribers" in near future !


-- 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 review. Thanks!

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

2 years 6 months ago #61956 by ggppdk
Hello

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


-- 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 review. Thanks!

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

2 years 6 months ago - 2 years 6 months ago #61962 by ggppdk
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 ...


-- 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 review. Thanks!

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

2 years 5 months ago #62436 by ggppdk
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)


-- 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 review. Thanks!

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

2 years 4 months ago #62700 by arc3c
Thanks for your help. Can I somewhere download the flexicontent 3.15?

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

2 years 4 months ago #62701 by ggppdk
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


-- 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 review. Thanks!

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

Moderators: vistamediajoomlacornerggppdk
© 2018 Flexicontent. All Rights Reserved.