Penny auction concept and how the timer works

Posted by madi on Programmers See other posts from Programmers or by madi
Published on 2014-06-06T02:49:31Z Indexed on 2014/06/06 3:38 UTC
Read the original article Hit count: 259

Filed under:
|
|
|

I am creating a penny auction site using PHP yii framework. The main consideration of the system is to update the database records of all active auctions (max 15 auctions) with the current ticker timer. I am seeking for advice on how i should design the system where every auction item will have a its own countdown timer stored in the database and when someone bids the auction item, the counter resets to 2 min. Every users who are connected to the system should see the same countdown timer for that particular auction. I am little confused on how i should design the system. Will there be a performance issue when there are frequent updates to the database (Mysql) where 15 active auctions are updated every seconds, the countdown timer decreases by a second in the database table for the particular auction.

Schema Sample for auction_lots: Auction_id,startdatetime,counter_timer,status

I am seeking for advice on how I should design this. Please help. Thank you!

© Programmers or respective owner

Related posts about php

Related posts about mysql