Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

Re: Large table query code help!

by moritz (Cardinal)
on Feb 02, 2012 at 20:03 UTC ( #951517=note: print w/ replies, xml ) Need Help??


in reply to Large table query code help!

Where does the lib::Db come from? it doesn't seem to be used anywhere.

Anyway, you speak of "issues", but don't mention what the problem is. Is the database engine throwing an error? If yes, which? Or are you getting a different result than expected? If yes, what do you get, what do you expect?

If you are unsure what values some variables contain, use Data::Dumper to find out.

One problem I can see with your code is that if @data doesn't contain a number of items that is divisible by 50, then the last query will have lots of trailing undefs. Not sure if you want that.


Comment on Re: Large table query code help!
Select or Download Code
Re^2: Large table query code help!
by Anonymous Monk on Feb 02, 2012 at 20:09 UTC

    the last query will have lots of trailing undefs. Not sure if you want that.

    If the database library maps those to NULLs, it should not be a problem (they match nothing).

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (2)
As of 2014-09-22 02:22 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (177 votes), past polls