Page 1 of 1

Query on One table

Posted: Wed Dec 03, 2008 1:32 pm
by dude81
Hello all,

I've designed an table on which queries will be huge as the entire website is going to do most of the queries, which is nothing but product_details(InnoDB type- this contains various specifications of the products, especially used in shopping cart and bidding place). Now I've to build purchase history, where I considered upon asking for product details in the user purchase history, Ill pull the data from same table i.e. product details. Also if user wants to resell the same purchase made, there would be an update query on the product_details table

Now my question is when 10,000 users would hit this website, the most queries that are performed on product_details table. Would this table get crashed by any chance or show any other wrong functionality? Could somebody share their experience please or opinion please.