I'm downloading several million records from an Oracle database to a MySql database and would like to use fetchall_arrayref() to do it. However, there are so many records that my computer memory fills up and then crashes.
Is there a way of "chunking" the data coming down or do I need to use the fetch_arrayref() and do it one record at a time (several million times)? Thanks, Phil
