Questions tagged [unbuffered-queries]
20 questions
0
votes
1 answer
Laravel and MemSQL columnstore, unbuffered queries are active
i'm currently working with MemSQL Columnstore and trying to integrate it with laravel 5, but everytime i tried to make a query I got the following error
SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are…
Michell Quintero
- 1
- 3
0
votes
1 answer
Unbuffered queries in MSSQL using php pdo
I'm looking for an MSSQL alternateive for this below constant
MYSQL_ATTR_USE_BUFFERED_QUERY
$pdo->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, false);
Above setiing is for MYSQL database. Is there any constant for MSSQL. If not how could i…
Ravi MCA
- 2,491
- 4
- 20
- 30
0
votes
2 answers
I get 2014 Cannot execute queries while other unbuffered queries are active when doing exec with PDO
I am doing a PDO::exec command on multiple updates:
$MyPdo->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY,true);
$MyPdo->exec("update t1 set f1=1;update t2 set f1=2");
I am doing it inside a transaction, and I keep getting the following…
Itay Moav -Malimovka
- 52,579
- 61
- 190
- 278
0
votes
1 answer
Zend_Db and unbuffered queries
I have a long running query which I try to fetch via an unbuffered pdo-statement (see code next).
But when I 'execute' the query unbuffered, or I do a 'fetchAll', the timings (also see under) don't really change much...
What I thought is that…
Steven Van Ingelgem
- 872
- 2
- 9
- 25
-1
votes
1 answer
Mysqli: skip rows after use_result
I pass arbitrary multi-statement SQL to Mysqli (using mysqlnd) and retrieve the result set. SELECT statements can contain LIMIT clause (or not). What i need is to limit fetched rows to 1000 (hardcoded limit). That's what i have:
define('SAFE_ROWS',…
Bars
- 194
- 1
- 7