Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re: Large table query code help!

by moritz (Cardinal)
on Feb 02, 2012 at 20:03 UTC ( [id://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.

Replies are listed 'Best First'.
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
Domain Nodelet?
Node Status?
node history
Node Type: note [id://951517]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others cooling their heels in the Monastery: (2)
As of 2024-04-19 01:39 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found