On Sun, Mar 20, 2011 at 7:11 PM, Miloš Vučinić <[email protected]> wrote: > 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.
These aren't extraordinary numbers as far as any normal DB is concerned. Just be sure that your tables are properly indexed. > 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 ? Yes. That sort of traffic shouldn't be a problem. > 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 ? That depends on what the other uses for the DB are. I wouldn't think that answering a poll would interfere much, if at all, though. > Also, is MySQL going to work properly because it is a lot of queries > and a large database is needed for this.. It's neither a lot of queries nor an enormous dataset. Lots of sites use MySQL to handle millions of records and *many* thousands of inserts a day. > 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.. You can cache an entire page. But, for your purposes, it might be best to cache individual poll views. Will you have more than one poll active at a time? -- 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
