Database Performance Issues

[Ollie]

language definitions and descriptions are not the same!
Just open any category in admin and look into name field for english and chinese variants. You will see that chinese value is empty. Name is "description" of your category and you responses for this data. 
Other text, that built-in Abantecart calls language definitions and can be changed via system->localization->language definitions. Probably some definitions are missed. You can enable warnings in settings about that and catch all of them.

I'm familiar with language definitions. As I said, I don't use Abantecart's translation. I use a third party translation service that translates my website. With this service, I don't need to use language definitions. I'm curious as to why I was having those problems. There's more than just translation. The page layout was also messed up and the category menus were incomplete or missing. Can you talk to other core developers to see if you guys can help me figure out why this happened? Might this have been caused by changing mysql to amysqli? I put it back to mysql and so far it looks good.

[Basara]

I had Cloudflare purge the cached version of the website. I'm waiting to see what happens. I appreciate your feedback on this.

Hello. Cloudflare CDN can be a problem and this explain languages messed up (as well as issue self resolve). Try to decrease Cloudflare caching level (turn OFF Autominify and scripts caching, Cloudflare Rocket loader ...etc)

[Ollie]

Hello. Cloudflare CDN can be a problem and this explain languages messed up (as well as issue self resolve). Try to decrease Cloudflare caching level (turn OFF Autominify and scripts caching, Cloudflare Rocket loader ...etc)

Ever since I purged cache on CloudFlare, restored my files and changed back to mysql, my shopping cart stabilized. I haven't seen the problem yesterday or today. I'll see about making the changes you recommended on CloudFlare. Also, I'd like to change the config setting from mysql back to amysqli (since this seems to be faster), but I'm afraid that this might bring those performance issues back. Can you tell me for sure that those problems were not being caused by the changes I made? Originally, I had the config file set to mysql, which was changed to amysqli, which was replaced with a new file provided by Abolabo. Thanks for your assistance.

[Basara]

In my opinion languages messed up by Cloudflare. I use it some time before and it is good service but if cache only static content like images. Other optimizers/loader usually give unexpected results.

[Ollie]

In my opinion languages messed up by Cloudflare. I use it some time before and it is good service but if cache only static content like images. Other optimizers/loader usually give unexpected results.

As I said, the problem was more than just translation. The layout was also messed up, including Category menus that were either missing or incomplete. Can you answer this question:

Can you tell me for sure that those problems were not being caused by the changes I made? Originally, I had the config file set to mysql, which was changed to amysqli, which was replaced with a new file provided by Abolabo. I need to know with a 100% certainty that this was not the reason for the problem.

PS: Website is slow again as I'm still using mysql instead of amysqli.

[abolabo]

PS: Website is slow again as I'm still using mysql instead of amysqli.

i really do not understand how relates your custom translation solution with database driver.

[Ollie]

PS: Website is slow again as I'm still using mysql instead of amysqli.

i really do not understand how relates your custom translation solution with database driver.

The problem was not just translation, as I explained in my previous post. Are you saying that those problems have nothing to do with changing from mysql to amysqli?

[abolabo]

The problem was not just translation, as I explained in my previous post. Are you saying that those problems have nothing to do with changing from mysql to amysqli?

please do few tests with https://developers.google.com/speed/pagespeed/insights/ with both db-drivers and post page load time here.
i need a proofs:)

[Ollie]

please do few tests with https://developers.google.com/speed/pagespeed/insights/ with both db-drivers and post page load time here.
i need a proofs:)

I need to know for sure that I won't have the same problems if I change to amysql. Can you please answer my previous question?

[abolabo]

it's not related to db-driver.

i answered earlier.

[Ollie]

it's not related to db-driver.

i answered earlier.

Sorry, I'm not familiar with "db-driver". Does this mean that the problem was not caused by me changing to amysqli? Can I safely use it with version 1.2.0? I'm trying to avoid the same problems I was having before.

[Basara]

Sorry, I'm not familiar with "db-driver". Does this mean that the problem was not caused by me changing to amysqli? Can I safely use it with version 1.2.0? I'm trying to avoid the same problems I was having before.

Hello. "db-driver" mean Database driver type. Sorry for inconvenience.
In any way amysqli (or MySQLi ) is a MySQL Improved driver. You should use MySQLi or PDO_MySQL (another db driver)   because MySQL is officially deprecated and will be removed in the future PHP servers.
http://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php

[Ollie]

Hello. "db-driver" mean Database driver type. Sorry for inconvenience.
In any way amysqli (or MySQLi ) is a MySQL Improved driver. You should use MySQLi or PDO_MySQL (another db driver)   because MySQL is officially deprecated and will be removed in the future PHP servers.
http://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php

Thank you for the heads-up. I changed to amysqli and so far it's working great. None of the problems I had before.