http://www.notgoingtouni.co.uk - on it's launch it took traffic more than what you describe and cakephp didn't crumble one bit.
Just make sure your hosting is up to scratch and be really good friends with a sys admin! On Mar 20, 11:39 pm, cricket <[email protected]> wrote: > 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
