Problem with Large Query Returns from MS-SQL
- From: jordanmueller@xxxxxxxxx (Jordan Mueller)
- Date: Fri, 25 May 2007 12:10:09 -0400
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
- Follow-Ups:
- Re: Problem with Large Query Returns from MS-SQL
- From: Fi Dot
- Re: Problem with Large Query Returns from MS-SQL
- Prev by Date: DBD::Oracle -- NULL LOB Locator is not "null"
- Next by Date: Re: Problem with Large Query Returns from MS-SQL
- Previous by thread: DBD::Oracle -- NULL LOB Locator is not "null"
- Next by thread: Re: Problem with Large Query Returns from MS-SQL
- Index(es):
Relevant Pages
|
