Thanks for the responses, it's quite a relief :) I'm glad that this kind of traffic is not actually large amount of traffic.
Yes I will have more polls at the time, so I will have to make an add action view cached, which will basically generate poll from the information about questions in DB. (Add will have a param which will tell which poll to add).It is a good idea to cache them all. And also , yes I will be good friends with sys admin, I will have a meeting with him today :) Thank you all, Milos Vucinic On Mar 21, 1:14 am, Shaz <[email protected]> wrote: > 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
