hi, what is your speed expectation ? do you have any minimum and maximum time limit ?
why not try to do the save only once...like firing all the insert in 1 shot to the db. or just create raw insert command and run the execute.. On Tue, May 8, 2012 at 12:27 AM, John Hardy <john.c.ha...@gmail.com> wrote: > While code optimization should be done, i would be more interested in your > network, database setup/tuning and your hardware specs. > > Test your algorithm outside of the cake framework to compare speeds > On May 7, 2012 7:48 AM, "supp...@deep-coding.net" < > supp...@deep-coding.net> wrote: > >> Hey, >> >> I have a problem, I have to handle many database requests, but it >> tooks to much time. >> The user can upload a xml file, then I am running a foreach, to create >> an array from the data of the xml file. >> Then I am saving this data with the save() method, but it tooks to >> much time. >> For testing I have uploaded a file with 1,200 datasets and it tooks 24 >> seconds to read all datasets, create the arrays and save it into the >> database. >> I don't know what I can do to rush it up. >> Can anyone help me please? >> >> Thanks Alex >> >> -- >> 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 >> > -- > 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 > -- 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
