in reply to Re: fetchall_arrayref({}) call freezing
in thread fetchall_arrayref({}) call freezing

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.
  • Comment on Re^2: fetchall_arrayref({}) call freezing

Replies are listed 'Best First'.
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