On Apr 3, 10:40 pm, "Chris Hartjes" <[EMAIL PROTECTED]> wrote:
> 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.
Shell is not the direct solution as it's exporting of data for
admin and users.
> 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.
Think about phpMyAdmin?
> > 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.
LOL. I'm not ignorant about you;-)
> 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.
Yup, good advice.
--
<?php echo 'Just another PHP saint'; ?>
Email: rrjanbiah-at-Y!com Blog: http://rajeshanbiah.blogspot.com/
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
