Author Topic: Database Performance Issues  (Read 15431 times)

Offline Ollie

  • Sr. Member
  • ****
  • Posts: 253
  • Karma: +27/-1
    • View Profile
    • Assistech
Re: Database Performance Issues
« Reply #15 on: February 15, 2016, 04:21:47 PM »
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.
Assistive technologies for people with special needs:
https://assistech.com/store/

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5318
  • Karma: +268/-2
    • View Profile
Re: Database Performance Issues
« Reply #16 on: February 16, 2016, 01:10:38 AM »
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)

Offline Ollie

  • Sr. Member
  • ****
  • Posts: 253
  • Karma: +27/-1
    • View Profile
    • Assistech
Re: Database Performance Issues
« Reply #17 on: February 16, 2016, 07:25:37 AM »
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.
Assistive technologies for people with special needs:
https://assistech.com/store/

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5318
  • Karma: +268/-2
    • View Profile
Re: Database Performance Issues
« Reply #18 on: February 16, 2016, 08:08:20 AM »
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.

Offline Ollie

  • Sr. Member
  • ****
  • Posts: 253
  • Karma: +27/-1
    • View Profile
    • Assistech
Re: Database Performance Issues
« Reply #19 on: February 16, 2016, 12:44:03 PM »
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.
« Last Edit: February 16, 2016, 12:46:37 PM by Ollie »
Assistive technologies for people with special needs:
https://assistech.com/store/

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2004
  • Karma: +309/-12
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Database Performance Issues
« Reply #20 on: February 16, 2016, 01:19:43 PM »
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.
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline Ollie

  • Sr. Member
  • ****
  • Posts: 253
  • Karma: +27/-1
    • View Profile
    • Assistech
Re: Database Performance Issues
« Reply #21 on: February 16, 2016, 01:30:22 PM »
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?
Assistive technologies for people with special needs:
https://assistech.com/store/

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2004
  • Karma: +309/-12
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Database Performance Issues
« Reply #22 on: February 16, 2016, 01:40:55 PM »
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:)
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline Ollie

  • Sr. Member
  • ****
  • Posts: 253
  • Karma: +27/-1
    • View Profile
    • Assistech
Re: Database Performance Issues
« Reply #23 on: February 16, 2016, 07:04:13 PM »
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?
Assistive technologies for people with special needs:
https://assistech.com/store/

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2004
  • Karma: +309/-12
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Database Performance Issues
« Reply #24 on: February 17, 2016, 07:51:53 AM »
it's not related to db-driver.
i answered earlier.
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline Ollie

  • Sr. Member
  • ****
  • Posts: 253
  • Karma: +27/-1
    • View Profile
    • Assistech
Re: Database Performance Issues
« Reply #25 on: February 17, 2016, 12:40:46 PM »
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.
« Last Edit: February 17, 2016, 12:44:12 PM by Ollie »
Assistive technologies for people with special needs:
https://assistech.com/store/

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5318
  • Karma: +268/-2
    • View Profile
Re: Database Performance Issues
« Reply #26 on: February 18, 2016, 01:54:55 AM »

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

Offline Ollie

  • Sr. Member
  • ****
  • Posts: 253
  • Karma: +27/-1
    • View Profile
    • Assistech
Re: Database Performance Issues
« Reply #27 on: February 18, 2016, 05:29:13 AM »
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.
« Last Edit: February 23, 2016, 10:30:30 PM by Ollie »
Assistive technologies for people with special needs:
https://assistech.com/store/

 

Powered by SMFPacks Social Login Mod