More stuff to learn then, at least it is encouraging to know moving from msaccess is a good idea Thanks for the help phil
On 29 Sep, 07:21, AD7six <[EMAIL PROTECTED]> wrote: > On Sep 28, 10:09 pm, Phil <[EMAIL PROTECTED]> wrote: > > > Newbie, slow response, wrong tools ? > > > I use ms access to run a small business and have decided to replace my > > app with > > linux, apache2, postgres 8., cakephp 1.2 > > > so far i have got as far as adapting the bookmarks tutorial by graham > > birdhttp://grahambird.co.uk/cake/tutorials/scaffolding.php > > > The problem is when I use it with 2500 records the response time is > > circa 100 secs > > Hi, > > > am I ? > > 1. displaying too big a data set > > Yes, but that won't account for 100seconds > > > 2. entirely in the wrong software with cakephp > > No, but there will be a number of things that you can do differently. > Stopping using msaccess was one such fantastic decision already > made :). > > > 3. should not be using scaffolding > > Scaffolding is there just for starting out, you would never use > scaffolding on a real site. > > > 4. made some error with the table or coding > > If you use bake, you will get editable code instead of getting cake to > generate a lot of logic on the fly all the time (see screencasts) > If you run with debug set to 0 cake caches some setup info. > If your tmp dir is not writable or missing, this is often a cause of > slow response > If you have any associations you could find you /think/ you are > looking and retrieved a small amount of data whereas infact you > retrieved a vast amount of data which you are not using. > > Once you have a simple application, if you then are still getting a > slow response identify at least where the time goes (use the log > function before and after a method you suspect, or use a profiling > tool) - 100s is obviously extremely slow. > > hth, > > AD --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
