fida aljounaidi wrote: > > Hi > thanks for your answer > I mean a request that should return a lots of row. Its exactly a large > parameters under the Where In(id1,id2,...,id1000) clause. > I've tried with LongReadLen but it doesn't work.
You may have reached a limit on the size of SQL handled if you do this sort of thing. Personally, I'd not do what you are doing as I doubt it is very efficient and I'd find another way to do this. > i've put a trace() function to have the log. I've noticed a freeing > parameters request before the end of selectall_arrayref() execution. > Not an array reference come after this freeing parameters. > > I'm thinking on setting up a paging of a result? > what do you think about that > Fida But we have not indication that the result-set size is the problem yet so paging would make no difference. As I said, it may be worth posting a small example as we cannot tell from your description what may be going wrong. Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com > 2010/1/8 Martin Evans <[email protected] > <mailto:[email protected]>> > > fida aljounaidi wrote: > > Hi > > > > I have a problem whith one large select request. > > > > A connection is opened by dbi perl but ended without giving any > result. > > Th perl script end with an error like > > > > "Not an ARRAY reference" > > > > When i observed mysql log, i found that the connection opened is ended > > without any result. > > When i execute sql query directly into the db server, it succeed. > > > > i didn't find anyt ips about that. > > However i found a kind of definition of buffersize on > dbi:teradata. (a kind > > of parameter to define into dbi->connect instruction. > > > > Any idea about that? > > > > Thanks a lot. > > > > What do you mean by "one large select request" - do you mean it should > return lots of rows or a row contains a column that is very large? > > See LongReadLen for retrieving large columns. > > We'd have to see a small self contained example to diagnose where the > "Not an ARRAY reference" is coming from. > > Martin > -- > Martin J. Evans > Easysoft Limited > http://www.easysoft.com > >
