Hello Tommy Pham,
Am 2010-03-23 18:17:56, hacktest Du folgendes herunter:
> Let's go back to my 1st e-commerce example. The manufacturers list is
> about 3,700. The categories is about about 2,400. The products list
> is right now at 500,000 and expected to be around 750,000. The site
> is only in English. The store owner wants to expand and be I18n:
> Chinese, French, German, Korean, Spanish. You see how big and complex
> that database gets? The store owners want to have this happens when a
> customer clicks on a category:
I have something like this similar but my database is arround 2 TByte
and stored on seven Sun Fire X4150 and I have only two X4100M2 as
redunant Front-End.
Your 750.000 items look a little bit like a gadget database...
I habe several 10 million rows and 200 columns and this is why I splited
the Database into seven Severs.
Even threading would not work on this database, because the botleneck is
the Disk-IO.
A query about the "Irak-War" and "Backwater" would kill a singel server.
> * show all subcategories for that category, if any
> * show all products for that category, if any,
> * show all manufacturers, used as filtering, for that category and subcategories
> * show price range filter for that category
> * show features & specifications filter for that category
> * show 10 top sellers for that category and related subcategories
> * the shopper can then select/deselect any of those filters and
> ability to sort by manufacturers, prices, user rating, popularity
> (purchased quantity)
> * have the ability to switch to another language translation on the fly
> * from the moment the shopper click on a link, the response time (when
> web browser saids "Done" in the status bar) is 5 seconds or less.
> Preferably 2-3 seconds. Will be using stopwatch for the timer.
Nothing special...
Describtion for the products sould be a seperated server
Q: Do you real mean, you put 750.000 product describtions into
the database and then create a new colum for ech language?
Your Mini-Shop could be done with redunancy using two Database- and two
Web-Servrs.
> is not even enterprise requirement. I may have another possible
> project where # products is over 10 million easily. With similar
More the 10 mio products? Whats this?
I a in the electronic business, and geting 10 mio products, mean, take
ANY western manufacturers of microchip manufacturers, passive parts,
connectors and such into a database?
Put asian manufactures to are arround 30 mio in total.
If you say, you put the FITS data from the ESO into it, I could
understand, but your explanation is a little but to unbelivable.
Thanks, Greetings and nice Day/Evening
Michelle Konzack
Systemadministrator
24V Electronic Engineer
Tamay Dogan Network
Debian GNU/Linux Consultant
--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
<http://www.tamay-dogan.net/> Michelle Konzack
<http://www.can4linux.org/> Apt. 917
<http://www.flexray4linux.org/> 50, rue de Soultz
Jabber linux4michelle@xxxxxxxxxxxxx 67100 Strabourg/France
IRC #Debian (irc.icq.com) Tel. DE: +49 177 9351947
ICQ #328449886 Tel. FR: +33 6 61925193
<<attachment: signature.pgp>>
