Prestashop + very slow google smtp mails = slow order confirmation

[Diwad]

Hi guys. Im using prestashop with VPS and we are using gmail for our mail (with our domain). Problem is that when I have configured smtp for gmail and client makes an order displaying confirmation page is very very slow. It takes from 5 to 20s to display confirmation page. Sometimes client clicks 2 times which doubles his order.

 

My question is - is there a way co configure mail server on my vps and still be able to use gmail?

 

Thanks for help.

Regards

Edited June 28, 2017 by Diwad (see edit history)

[bellini13]

You should speak to your hosting provider about this.  You should be able to configure your php to use an smtp server, however I suspect it would still suffer from delays.

[Diwad]

But will I still be able to use gmail?

 

What is the best way of having fast validation/confirmation page? Mail php function?

[bellini13]

As I said, you should contact your hosting provider for support.  They will need to tell you what your options are.

[gkhorkheli]

Hello, 

Have you solved this issue ?

i'am suffering too...

[Scully]

Using SMTP as mail setting I the most common problem with such delays. Your remote SMTP server might respondes slowly or there are DNS resolution issues. That said, we never use SMTP to a remote machine but instead the mail function from PHP. The simple advantage is: no cross server communication.

[bellini13]

while i agree that using php mail is the most desirable way, it is not always an option depending on your hosting provider.  and unfortunately the swiftmailer library used by Prestashop is slow when using gmail or office365 SMTP (which both require SSL or STARTTLS encryption). 

[Scully]

You are correct. But friendly asking the hosting provider to enable php mail would still be an option.

[gkhorkheli]

hello guys thank you for your attention and time.

 

my problem was mysql performance if someone will have this kind of problem use this 

 

https://dev.mysql.com/doc/refman/5.7/en/server-configuration.html

mysqld_safe --key_buffer_size=384M --table_open_cache=4000 \
           --sort_buffer_size=4M --read_buffer_size=1M &

this command helped me.

 

Regards.

Edited September 6, 2017 by gkhorkheli (see edit history)

[Diwad]

So you are not facing any delays in orsstasjop order confirmation? How much does it take to display confirmation page for you?

[Scully]

MySQL Settings might help in general for tuning the database. But this kind of settings do not change the big pictures in the way from 20 seconds to 2 or 3 seconds. In my personal opinion the MySQL settings also cannot resolve a problem with SMTP connections.

[gkhorkheli]

So you are not facing any delays in orsstasjop order confirmation? How much does it take to display confirmation page for you?

 

now it takes maximum 10 seconds.

 

 

MySQL Settings might help in general for tuning the database. But this kind of settings do not change the big pictures in the way from 20 seconds to 2 or 3 seconds. In my personal opinion the MySQL settings also cannot resolve a problem with SMTP connections.

 

may be i don't know but my problem was not SMTP connection delay because i disabled order_conf sending also commented PaymetModule Classe's Mail::send section .etc. from Backoffice configuration disabled mail sending but order confirmation still was remaining exactly same .

 

So this was mysql issue  

[bellini13]

you don't say what version of Prestashop you are using, but more recent versions allow you to disable the sending of emails from the back office (without making code changes).

[Diwad]

I will dig up this thread..

 

We still have some delays in confirmation (it takes about 10s to show the confirmation screen). We can disable email notifications, but it is not an option for us. Client needs to have it on his email.

 

Does google smatp has some alternative severs?

[884483048]

Have you found the solution?