Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

Re^2: Undefined Array Reference

by Anonymous Monk
on Apr 23, 2009 at 03:50 UTC ( #759472=note: print w/ replies, xml ) Need Help??


in reply to Re: Undefined Array Reference
in thread Undefined Array Reference

The reason for that is a query result from a database, each array ref, since I can not join these tables, are each from these tables, and I don't know how many records each one will be returning, that is the reason for this sample code.


Comment on Re^2: Undefined Array Reference
Re^3: Undefined Array Reference
by lostjimmy (Chaplain) on Apr 23, 2009 at 13:02 UTC
    I'd really like to know why you can't join the tables...
      The tables are too big, they are already a logic file from 3 different tables each. Thats the only way, I have to get the values from the first and after finding the account numbers I can get the rest from the other table, manipulate the results in the array ref and format a report
        Perhaps indexes on your tables could help. Or instead of trying to turn Perl into a database, create subsets of your tables in temp tables and query those.

        I know from personal experience that this type of processing is best left to databases even though Perl is much cooler than SQL

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://759472]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (11)
As of 2015-07-02 08:33 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (31 votes), past polls