Re: fetchall_arrayref({}) call freezing

in reply to fetchall_arrayref({}) call freezing

Hi,

we can't see whether this is a perl related problem or a database problem. To give some advice or to collect some experience here with several databases you should add some information:

Database version
Database client version
DBI version
DBD::xxx version
create statement of Table1
does it happen always with the same table or with different sql statements?

Regards
McA

Comment on Re: fetchall_arrayref({}) call freezing

Replies are listed 'Best First'.
Re^2: fetchall_arrayref({}) call freezing by Laurent_R (Canon) on Mar 11, 2014 at 22:20 UTC
I agree, it looks as a database problem. The time to execute a DB query is really not proportional to the number of matching results, but on the complexity of what it has to do to fetch these results. You are not saying enough to elicit a really useful answer.	[reply]
Re^3: fetchall_arrayref({}) call freezing by banesong (Acolyte) on Mar 12, 2014 at 12:52 UTC
The thing that is killing me on this particular query is it really as simple as fetching rows from the table - no joins, no where statement, nothing! This is as simple a query as I can do. When executing the query in SSMS, it takes 00:00:00 to run, and returns 369 rows.	[reply]

In Section Seekers of Perl Wisdom