Thanks.
I think that if I append (rather than overwrite) each report with each table, I
could restructure the code like you suggest. Thanks for pointing that out - it
hadn't occurred to me.
> my %sth;
> for (0..$#tables){
> $sth{$tables[$_]} = $dbh->prepare(
> "SELECT * FROM $theTable WHERE usubjid = ?"
> );
> }
I already tried something like that, but using an array rather than a hash. Is
there a reason why an array wouldn't work?
> Do you have indexes on the usubjid column in all tables?
Yes, and indexing made a huge speed improvement, so I know it worked.
Thanks again for all your suggestions.
Harry
--------------------------------------------------------------------------
AstraZeneca UK Limited is a company incorporated in England and Wales with
registered number: 03674842 and a registered office at 15 Stanhope Gate, London
W1K 1LN.
Confidentiality Notice: This message is private and may contain confidential,
proprietary and legally privileged information. If you have received this
message in error, please notify us and remove it from your system and note that
you must not copy, distribute or take any action in reliance on it. Any
unauthorised use or disclosure of the contents of this message is not permitted
and may be unlawful.
Disclaimer: Email messages may be subject to delays, interception, non-delivery
and unauthorised alterations. Therefore, information expressed in this message
is not given or endorsed by AstraZeneca UK Limited unless otherwise notified by
an authorised representative independent of this message. No contractual
relationship is created by this message by any person unless specifically
indicated by agreement in writing other than email.
Monitoring: AstraZeneca UK Limited may monitor email traffic data and content
for the purposes of the prevention and detection of crime, ensuring the
security of our computer systems and checking Compliance with our Code of
Conduct and Policies.
--
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
http://learn.perl.org/
