|Perl: the Markov chain saw|
Re: Re: Re: Re: DBD::ODBC won't read past a certain recordby LanceDeeply (Chaplain)
|on Aug 06, 2003 at 15:49 UTC||Need Help??|
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:
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.