Re: For a better efficiency and speed question!

[Lotus1]

in reply to For a better efficiency and speed question!

I am suspecting that the line my $control_num = join ( ',', ('?') x @control ); where I am joining all the control numbers from the array "@control" is slowing down the query results.

Why worry about speed when you code doesn't work?

use strict;
use warnings;

my @control = qw ( 1 2 3 4 5 6 7 );
my $control_num = join ( ',', ('?') x @control ); 
print "cn=$control_num<<\n";

__DATA__
cn=?,?,?,?,?,?,?<<

[Anonymous Monk]

I am sorry but it does work, the reason why you see "?" when you run your little test code is because the question marks are "place holders" in the SQL query.