Bienvenido, Invitado
Recordarme

TEMA:

Slow time on saving records in Content Builder 7 meses 2 semanas antes #257801

  • Avatar de emrigas Autor del tema
  • emrigas
  • Fuera de línea
  • Fresh Breezer
  • Fresh Breezer
  • Mensajes: 11
  • Gracias recibidas: 0
Hi, I am on Joomla 3.9.26 on a shared hosting with the following settings:

PHP version: 7.3.27
memory_limit: 512M
max_execution_time: 600
max_input_time: 600
post_max_size: 128M
upload_max_filesize: 128M
opcache.enable: on (Default)

I use the BreezingForms Pro for Joomla 3 Version 1.9.1 build 941 together with Content builder in order to view and edit my records.

Problem:
My attempt to save a new record takes no more than 30 seconds.
But an attempt to save an old record takes 4 minutes.

I already tried the following solutions:
1) I turned off the mail notification.
2) I turned off the mode security firewall.
3) I also added the missing indexes in my DB as you describe on #217677 here:
crosstec.org/en/forums/37-contentbuilder...builder.html?start=6

4) I tried the solution #196258 on this topic:
crosstec.org/en/forums/5-bugs/112932-slo...trator.html?start=18

5) I asked my hosting provider to monitor in real-time while I tried saving a record through content builder.
They didn't see any spikes or heavy mySQL query generated but they saw so many queries running during those four minutes of saving the record.

I really do not know what else I can do but the problem still exists.

Any ideas? I can give you access to /administrator on Joomla or in Plesk Panel if necessary.

Thank you in advance.

Manos.

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

Slow time on saving records in Content Builder 7 meses 2 semanas antes #257810

  • Avatar de tihana.krivic
  • tihana.krivic
  • Fuera de línea
  • Moderator
  • Moderator
  • Mensajes: 7800
  • Karma: 3
  • Gracias recibidas: 550
Hi,

this is indeed something we see happening on rare occasions but could never find out what exactly there is causing this (every hosting is special and we no insight into their configurations, especially rate limits are hard to catch).

I mean, we can still give it a try and fiddle around right on your hosting, but what BF is doing are basically ordinary posts.

I could imagine that because we save the data in chunks to allow secure form saving in limited database environments, the hosting uses harsh rate-limits (in terms of slowing down) when a series of posts is incoming (which is required for chunked saving).

It can also be the database itself or a mod_security rule needing to observe everything before giving "green light" on posts.

Question: when you try to add new records through BreezingForms only (not CB), is it still slow time?

Regards,
Tihana

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

Slow time on saving records in Content Builder 7 meses 2 semanas antes #257815

  • Avatar de emrigas Autor del tema
  • emrigas
  • Fuera de línea
  • Fresh Breezer
  • Fresh Breezer
  • Mensajes: 11
  • Gracias recibidas: 0
Hi Tihana.

Thank you for the fast respone.

When I try to add new records through BreezingForms only, It is not so slow.
It takes almost 30 seconds to submit, which is acceptable.

But through CB, it takes 4 minutes!

Our work demands to edit older records every day. We do a lot of edits per day.
So imagine that we have to wait 4 minutes in each and every edit from the moment we press the submit button until it saves on database.

Is there any solution to this problem?
Please help us. We really like BF and we want to keep using it.

Kind regards,
Manos.

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

Slow time on saving records in Content Builder 7 meses 2 semanas antes #257817

  • Avatar de tihana.krivic
  • tihana.krivic
  • Fuera de línea
  • Moderator
  • Moderator
  • Mensajes: 7800
  • Karma: 3
  • Gracias recibidas: 550
Hi,

please try this:
crosstec.org/en/forums/1-forums/109635-c....html?start=0#159077

Also, please check php_error_log, and see if there is some errors or warning.
If you can't find it, ask your host provide for this

Hope this helps

Regards,
Tihana

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

Última Edición: Post by tihana.krivic.

Slow time on saving records in Content Builder 7 meses 2 semanas antes #257899

  • Avatar de emrigas Autor del tema
  • emrigas
  • Fuera de línea
  • Fresh Breezer
  • Fresh Breezer
  • Mensajes: 11
  • Gracias recibidas: 0
Hi Tihana

I entered a double value (as Pedro81 say) in the "Synch Limit Per Turn" option at ContentBuilder System plugin and now there is a little difference in saving time.

Instead of 4 minutes, now it takes 3 and a half minutes to save.
I admit it is a progress but still it is a lot.

What to do next?
Thanks.

Kind regards,
Manos.

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

Slow time on saving records in Content Builder 7 meses 2 semanas antes #257900

  • Avatar de emrigas Autor del tema
  • emrigas
  • Fuera de línea
  • Fresh Breezer
  • Fresh Breezer
  • Mensajes: 11
  • Gracias recibidas: 0
Also I checked the php error logs in hosting panel but no errors or warnings have been recorded there.

Thanks.

Kind regards,
Manos.

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

Moderadores: ForumSupport
Tiempo de carga de la página: 0.057 segundos