PHP / MySQL - highly transactional programming & thousands of concurrent users?
Posted on 2009-04-07
# Strong understanding of highly transactional programming
# Code optimization to support thousands of concurrent users
I've just seen these included in the specs for a job advertisement for a PHP, MySQL Web Developer. Could you give me some ideas / examples of regular solutions / patterns to solve these problems.
What is highly transactional programming? Is this just a fancy term for a web app / site that will have to do a lot of DB updates?
What are the normal methods to accommodate high numbers of concurrent users in web apps. What can i do in the PHP / MySQL? or is it really down to Apache / MySQL Server and the hardware to deal with this?