On Thu, Apr 3, 2008 at 1:13 PM, R. Rajesh Jeba Anbiah <[EMAIL PROTECTED]> wrote: > > Cake's default way of dumping array in controller and iterating > in view file, works only for the small data. But, on a typical project > that requires "exporting of data", it doesn't work as it runs out of > memory. This needs fetching the record one-by-one like I mentioned > above.
I understand. Sounds to me like something that exports data like this is not suited to be a action within a controller. Maybe you should look into making this a Cake shell task, as that would let you use all the Cake goodness and be able to run from the command line. Either that or you'll have to run queries using LIMIT and OFFSET to grab what you need one chunk at a time. I don't know any scripting language that handles sucking in 600,000 records via a web page. > BTW, whenever you reply here with your remarks, I thought of > asking "do you really use CakePHP?" SCNR For a guy who calls himself "Just another PHP saint", that's quite a bold statement. Good thing my life doesn't revolve around worrying about what ignorant people think about me. Yes, I do use CakePHP. Otherwise I'd be wasting my time here. Don't blame me for failing to understand what your problem is. Maybe you should look into how you're asking your questions. -- Chris Hartjes Internet Loudmouth Motto for 2008: "Moving from herding elephants to handling snakes..." @TheKeyBoard: http://www.littlehart.net/atthekeyboard --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
