Thanks ! I have made on paper the model of DB. Every poll will have it's questions and answers in 2 different tables (2 tables for all polls), and every answer will have the poll and specific question to which is answered so that part is covered.
Although it has now came to my mind, that I will actually be making a lot more inserts having in mind that I will have to save each answer separately for the poll... Do you think it can make a problem, or is it OK solution ? Does this type of traffic makes problems to databases All the best, Miloš Vučinić On Mon, Mar 21, 2011 at 00:21, Simon Males <s...@sime.net.au> wrote: > > Also, is MySQL going to work properly because it is a lot of queries > > and a large database is needed for this.. > > I'm not an experienced CakePHP developer but my suggestions from a DB > point of view are: > > * Use InnoDB as a storage engine. > * INSERTs are cheaper then UPDATEs. So the 'vote' is written as a new > row, rather then updating an existing one. But more development is > required to compute a summary table which will represent the poll as a > whole. > > > -- > Simon Males > -- 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
