Query on One table

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
dude81
Forum Regular
Posts: 509
Joined: Mon Aug 29, 2005 6:26 am
Location: Pearls City

Query on One table

Post 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.
Post Reply