Hello, I am about to make a poll web site for my faculty. Everything about it is OK, except that it is expected to receive a around 40.000 answers to polls per year. But to make it a little worse, it is expected to receive 90% of these in some 4 months which makes it around 9000 per month , or a 300 per day.
This is all statistical info, what is expected is to have lot's of days when the web site will not be used, but around 30 days when it will receive 300-500 polls a day, in about 12 hours of the day (nobody will answer these polls at 3am etc ..) So I have to make it to work with a lot of large inserts to my database (one poll has approx 50 questions - fields in DB). Having in mind that I have never worked with this amount of traffic, my questions are following: Can cake put up with this ? If a database is shared (another faculty web sites are working on it) is it going to slow them down a lot, or should this be a dedicated server job ? Also, is MySQL going to work properly because it is a lot of queries and a large database is needed for this.. Is it possible to cache content for layout ? The polls are going to be made from back end and stored in a DB. When somebody needs to answer a poll the web site needs to generate it from info from DB. It would be nice to cache it, but how to do that when it is content for layout, and not some element view component.. Thanks a lot ! Milos Vucinic -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
