Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Mysql Database For A Large Number Of Products

  • poppedweb
  • Authorized Reseller
  • Members
  • Join Date: 02-Aug 16
  • 493 posts

Posted 20 March 2018 - 06:30 AM #1

7. after started website, on some time later(might be years later), I might will need to pay someone to customize entire system like this; each language will have their own separate table on database. because cs-cart company don't wants extra work for themselves and keeps all languages in one table. but if you search anything, MySQL server has to scan every records even if it's not included on those tables. for example, if you search in Russian Language anything, logically we know it's can't be found in arabic or chinese tables. so, why then MySQL server has to scan all those records? of course, in this case, you will have to have a separate URL stricture for every language and visitors will search from there. for example; ru.cs-cart.com visitors has to search only from Russian language tables. imagine that you have 1 million products, 10% of them has variation of 6. so, 100K * 6 = 600K + 900K = 1.5 million record and if you have 10 languages, it will be 15 million records. so, if someone wants search anything from Russian Language, why MySQL has to scan 15 Million records? it can be done with scanning just 1.5 millions records. but these things I will need to think very later, might be after years. but good to know now upfront now.




If you really have 1 million products then you won't have a simple setup. You will probably use Oracle database or such and not Mysql. However, if you really desire to use different languages then why not change the database all together? It is way easier to do, since you will only have to change the 'database' in the config field ('my_database' . CART_LANGUAGE) and change some session based values. You can also create functions / operations / triggers in mysql which would update the value across all the databases e.g. for the settings database.


Kind regards,

PoppedWeb | sales@poppedweb.com | https://poppedweb.com
TurnKey Website Design | Add-Ons | Performance Audits | Dedicated Server Management
24/7 Support | Response within an hour (during working hours).

  • Junior Member
  • Authorized Reseller
  • Join Date: 20-Aug 10
  • 144 posts

Posted 11 January 2019 - 05:49 PM #2

We run million plus catalogs for clients on CS-Cart, but you are always talking about an Enterprise-grade solution.


We often use: Galera Clutser for High Availability & Scalability - http://galeracluster.com


& Elastic Search for search/indexing & pre-loaded queries - https://www.elastic.co/


Individual results may vary.

FDG Web, Inc - Seattle Web Design : Custom CS-Cart Programming & Design | Toll-Free: 877.239.3083

Download Proposal Templates & Web Design Contract Samples