Re: Problem with Large Query Returns from MS-SQL
- From: Tim.Bunce@xxxxxxxxx (Tim Bunce)
- Date: Fri, 25 May 2007 18:10:50 +0100
Also try enaling tracing to see what's realy going on.
Tim.
On Fri, May 25, 2007 at 08:42:41PM +0400, Fi Dot wrote:
Hey!.
You haven't mentioned which DBD you're using.
I suspect it's DBD::ODBC.
If so, you might want to check out this page:
http://search.cpan.org/~jurl/DBD-ODBC-1.13/ODBC.pm
for 'odbc_query_timeout' parameter.
Try playing with it, _however_, it should be unlimited by default.
Have you measured how long does your 'long' query take?
Fi.
On 5/25/07, Jordan Mueller <jordanmueller@xxxxxxxxx> wrote:
Hello,
I am writing an application that is using DBI to access a MS SQL database
hosted on a remote server. I think I am having trouble with larger result
sets.
For example:
If I do
$stmt = "SELECT * FROM tableA";
Where where tableA is around 10 rows, then my test script returns all of
the
rows in the table and prints them out to the user on the browser.
However, if I do:
$stmt = "SELECT * FROM tableB";
Where tableB is around 6000 rows, the script does not produce any results
and continues with the rest of the script with an empty result set. Even
if
I put conditions on the query for the large table that would return only 2
or 3 rows, the result set is not returned.
Does DBI have some kind of default timeout setting that breaks off after
waiting for a query result? If so, can I alter it somewhere?
I should also mention that all of the queries I am trying in the script
work
fine when I directly call them on the database.
Thank you,
Jordan
- References:
- Problem with Large Query Returns from MS-SQL
- From: Jordan Mueller
- Re: Problem with Large Query Returns from MS-SQL
- From: Fi Dot
- Problem with Large Query Returns from MS-SQL
- Prev by Date: Re: Problem with Large Query Returns from MS-SQL
- Next by Date: Re: RFC: The future of Text::CSV_XS
- Previous by thread: Re: Problem with Large Query Returns from MS-SQL
- Next by thread: Re: RFC: The future of Text::CSV_XS
- Index(es):
Relevant Pages
|
