Increase "delete items" speed ?

More
7 years 2 months ago - 7 years 2 months ago #66085 by bendeb
Hello,
I use latest version of Flexicontent and Joomla 3.6.5.

I have to delete many items on backend because of restructuration of my content.

But the time it takes to delete multiple items is very very very long.
Even for one item only.

And during the process, I often have a 404 error inside my backend, as an article in editing form (I create a personalized 404 page).
And if it's not a 404 error, I have a SQL error about finder_tokens table or others, inside Joomla backend (I don't remember whoses).

Is there a way to correct this problem and increase delete items speed ?

Thank for your answer.

Regards.

Flexicontent 4.1.0b1
Joomla 3.9.18
Last edit: 7 years 2 months ago by ggppdk.

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

More
7 years 2 months ago #66086 by ggppdk
Hello

We clean up item data and our search index
but most delay is most probably due Joomla event:

onContentBeforeDelete

Explanation:
when you try to (permanetly) delete multiple items
then they are deleted via a loop 1 at a time
and for each of them the Joomla plugin event:

onContentBeforeDelete
is called

the above can be heavy, e.g. in your case it tries to update Joomla Smart search Index too
If you do not use Joomla smart search index then you can disable
the Joomla finder plugin and the Content finder plugin

and see if there is a difference

I can make an optimization for checking permissions that would save e.g. 1 second when delete 100 items
About deleting all flexicontent data at the end ... i am not sure since if process is interrupted then we would have some orphan data


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

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

More
7 years 2 months ago #66087 by bendeb
Thank ggppdk for your answer and explanations.
I'll try to disable smart search and see if the speed increase or not.
But for now, I have no more item to delete :silly:

Flexicontent 4.1.0b1
Joomla 3.9.18

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

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.516 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline