Thanks for the tip, Aldian. On Sun, Jul 19, 2020 at 7:01 AM Aldian Fazrihady <mob...@aldian.net> wrote:
> Hi, > There are more than one transactional data architectures to achieve the > goals, so only Amazon, eBay, or any other big commerce employees can answer > your question. > However, if you are using transactional SQL as Django is using it by > default, you probably need to learn about horizontal partitioning. > > Regards, > > Aldian Fazrihady > http://aldianfazrihady.com > > Pada tanggal Min, 19 Jul 2020 18.18, tristant <tran.trong....@gmail.com> > menulis: > >> Hi, >> >> I am wondering if anyone could point me to any documents or readings on >> how to big eCommerce sites such as Amazon or eBay implements the following >> situation: >> - A seller posts a product with an initial quantity, 'init_qty'. >> - An unknown number of clients access the product concurrently, add it to >> their shopping cart. >> - The site needs to manage the contemporary available quantity, >> "avail_qty", and all times. And switch the product to "unavailable" if the >> quantity drop to zero. >> - However, the effective "avail_qty" is only updated permanently in the >> database if and only if the client checks out and pays. >> >> For small eCommerce sites, updating the database frequently is not a big >> deal. But if the product count and client count is large, what is the >> efficient way to implement this? >> >> Thanks, >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Django users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to django-users+unsubscr...@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/django-users/dd2b979b-6f63-465b-b6e7-8a831e53bf28n%40googlegroups.com >> <https://groups.google.com/d/msgid/django-users/dd2b979b-6f63-465b-b6e7-8a831e53bf28n%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to django-users+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/CAN7EoAYizrLBxj%2BTTsRMjP-jRa0kuD4gN0uvbgRT5Qf_JKZdVA%40mail.gmail.com > <https://groups.google.com/d/msgid/django-users/CAN7EoAYizrLBxj%2BTTsRMjP-jRa0kuD4gN0uvbgRT5Qf_JKZdVA%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CA%2B%3DtPqkjtU5ZPMJuvJKhCFKssHxhWtxPEUTq6DwY1u2dC3Y0ww%40mail.gmail.com.
