Re: Will PHP ever "grow up" and have threading?

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@jabber.ccc.de 67100 Strabourg/France IRC #Debian (irc.icq.com) Tel. DE: +49 177 9351947 ICQ #328449886 Tel. FR: +33 6 61925193