Hi,
I am new to perl DBI
. I have a MySQL db with about 3-4 million records. I need to go and process each of these. Can I just give a select query and process each record through the fetchrow_array() function? I am worried that this might create a temporary file and/or take up all the physical memory.
Will the fetchall_arrayref(slice,max_rows) solve my problem? Will this take max_array records from the db for each call or will it take all the records, create a temp file and then operate on it?
Thanks a lot for any help.
Siva.
I am new to perl DBI
. I have a MySQL db with about 3-4 million records. I need to go and process each of these. Can I just give a select query and process each record through the fetchrow_array() function? I am worried that this might create a temporary file and/or take up all the physical memory. Will the fetchall_arrayref(slice,max_rows) solve my problem? Will this take max_array records from the db for each call or will it take all the records, create a temp file and then operate on it?
Thanks a lot for any help.
Siva.