Re: needed opinion from experienced cakephp user

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 <shazam...@gmail.com> 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 <zijn.digi...@gmail.com> wrote:
>
>
>
>
>
>
>
> > On Sun, Mar 20, 2011 at 7:11 PM, Miloš Vučinić <milosvuci...@gmail.com> 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
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php