Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw

Re: Re: Re: Re: DBD::ODBC won't read past a certain record

by LanceDeeply (Chaplain)
on Aug 06, 2003 at 15:49 UTC ( #281455=note: print w/replies, xml ) Need Help??

in reply to Re: Re: Re: DBD::ODBC won't read past a certain record
in thread DBD::ODBC won't read past a certain record


Do you need to select * from that table to do your accounting process? Have you tried just selecting the columns that you need? If that text/image column is not a necessary part of processing, don't select it. Limit the select columns to the ones you will be using.

If you really do need it though, here are some last few things to try before you re-write in Java.

Set the LongReadLen to the size specified by:

select maxsize = max ( Datalength( YourBigColumnName ) ) from Transact +ion
If you're loosing hope, before you do a clomplete re-write in Java, try Win32::ODBC. It's part of the ActiveState distribution. (It sounds like you've working in a Windows environment.) I've had to do this once before when I had trouble accessing large Text/Image data through DBI + IIS.

You can still use most of your existing code. You'll need to call SetMaxBufSize on the Win32::ODBC handle.

Good luck!

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (4)
As of 2021-05-14 06:28 GMT
Find Nodes?
    Voting Booth?
    Perl 7 will be out ...

    Results (149 votes). Check out past polls.