Hi ! Monks
I have written a perl programming to load the data from postgres database.My table has more than one crore data,I wanted to load the data in array references,What it will do?
will it cause any memory related problem if it has large number of data,below i have pasted the source code.I have practised for minimum data,I wanted to know while fetching more than one crore data what it will do.
#!/usr/bin/perl
use strict;
use warnings;
use DBI;
use Data::Dumper;
my $dbh = DBI->connect( 'dbi:Pg:database=san', 'san','psql')
or die "Can't connect to " ;
my $stmt="Select * from public.log_table";
my $ref = $dbh->selectall_arrayref($stmt) ;
print Dumper($ref)