#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2012
    Posts
    12
    Rep Power
    0

    How can I change my script to make multiple connections to do the job


    Hi,
    The following script does the job with one connection to the database however I need to add routines to make multiple connections to the database to do the job like adding another variable for example $conn=20; and avoid the table name conflicts, can someone please help me do that.

    Code:
    #!/usr/bin/perl
    use strict;
    use warnings;
    use DBI;
    
    my $tables=1000;
    my $rows=100000;
    
    my $dbh = DBI->connect ('DBI:Oracle:host=EM12;sid=orcl',"hr","hr")
            or die "Failed to connect to database: " . DBI->errstr;
    
    for my $i (1..$tables) {
    my $sql = "CREATE TABLE test_data$i(".
                                    "id PRIMARY KEY,".
                                    "group_id NOT NULL,".
                                    "created_at NOT NULL,".
                                    "text NOT NULL) AS ".
                                            "SELECT ".
                                                    "rownum,".
                                                    "MOD(rownum, 5),".
                                                    "TO_DATE('1-jan-07', 'dd-mon-yy') + INTERVAL '1' MINUTE * rownum,".
                                                    "CAST ('xyz' || rownum AS VARCHAR2(50)) ".
                                              "FROM dual ".
                                              "CONNECT BY LEVEL <= $rows";
    
    $dbh->do($sql) or die DBI->errstr;
    
    }
    
    $dbh->disconnect;
    Thank you very much in advance.
    Regards
    Terry
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Jun 2012
    Location
    Paris area, France
    Posts
    842
    Rep Power
    496
    Perhaps the use of threads will provide you with the right tools.

IMN logo majestic logo threadwatch logo seochat tools logo