I have a site at [url removed, login to view] The site is an auction website and each auction has a countdown timer, a winning bidder and a winning bid price. Each time somebody places a bid the countdown timer has 15 seconds added to it, the bidder changes to their name and the bid price increases by £0.05. The site uses ajax to update the information on the website each second and after each new bid is placed. Each user on the website sends a query to the mysql database to get the updated information. Current problems: Each user sends a query to the database and the results of this are downloaded in an ajax file, each user queries the database about 80 times a minute. The ajax file that updates the auctions is too large, about 2kb. Solution: I would like a coder to design a solution so that the information for all live auctions is held in cache. The cache will automatically be updated every second. This information will be, time left, winning bidder, current price. There may be upto 250 auctions running at any one time (although the current winning bidder and winning price will only be updating regularly on around 10 - 30 auctions). ----- When bidding please look at the site [url removed, login to view] and post in your bid your explanation of how you can solve the problem. Currently each user on the site utilises too much CPU on the server as each user queries the database every second to get the information. ----- The site at [url removed, login to view] is purely for demonstration purposes only, the real site URL will only be disclosed after your bid has been accepted. To view a similar site in operation look at [url removed, login to view] - this is how busy the website is, please consider that.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):
a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
internet explorer, 5,6,7, safari, firefox