|MYSQL slow queries in “slow queries log” - but same queries runs very fast manually|
| by Edwin Goei in Databases|
as title states, in my database various queries appear in the slow
queries log, but when I run them manually they run 10x faster.
for example a relatively simple select query with several order by
params takes often up to 100 seconds in log(yes table is very big)... but
when I run it myself on the same DB it takes 2 seconds or so.
I've examined the server's performance
|how to resolve General error: 2014 Cannot execute queries while other unbuffered queries are active. using PDO connection|
| by Steve O. in Databases|
While i am executing second Stored procedure with same connection
statement(Using PDO), getting the below error.
General error: 2014 Cannot execute queries
while other unbuffered queries are active. Consider using
Alternatively, if your code is only ever
going to run
|FirePHP not returning ajax request queries, yet returns normal page load queries|
| by asp.net in Web Design|
I am using firePHP(Zend profiler) on on FF 3.6.3(firephp addon
installed) and it returns queries, when I do a normal page load. Ajax
requests, however, are not returning the proper queries. I am using
Prototype 220.127.116.11 for ajax requests. Is there something I am missing?
Most of the write-ups seem to imply that this should work by default.
|mytop ( a mysql monitoring tool) thread view dosen't consider queries commited by other users in Queries|
| by Mahesh in Databases|
I ran a program which commits 2000 inserts into a table. but in mytop
thread veiw the item "Queries" which keeps track of number of queries is
increased just by 2 each time mytop view is refreshed and that is the
number of queries mytop commits itself to get info from mysql. I don't know
why the number of insert queries is not added... .
matter is that my command view has ju
|Good tool for converting mssql queries to mysql queries|
| by IHateMyJob2004 in Databases|
I found alot of question on stack about converting mysql to mssql, but i
would like to convert it otherwise.
From mssql server to
is there a (free) tool for this to do that without
connecting to the databases?
i have an sql query dump and i want to
convert that by putting that code in an tool.
|Join queries taking more execution time than their corresponding nested queries|
| by nishar7 in Coding|
I have 2 tables namely Person_Organization and Person_Organization_other
and nested query is :-
SELECT Person_Organization_id FROM
WHERE company_name IN
SELECT company_name from Person_Organization_other
Person_Organization_Id FROM Person_Organization
|How to avoid this PDO exception: Cannot execute queries while other unbuffered queries are active|
| by Matt in Programming Languages|
I'd like to print a simple table in my page with 3 columns,
style. If I try to retrieve the list of
arch. styles there is no problem:
ON buildings.id =
|I get 2014 Cannot execute queries while other unbuffered queries are active when doing exec with PDO|
| by Marti in Programming Languages|
I am doing a PDO::exec command on multiple updates:
$MyPdo->exec("update t1 set f1=1;update t2 set f1=2");
I am doing it inside a transaction, and I keep getting:
SQLSTATE[HY000]: General error: 2014
Cannot execute queries while
unbuffered queries are a
|Is it true that writing LINQ queries is not easy for complex queries?|
| by skriefal in Programming Languages|
Is it true that writing LINQ queries is not easy for complex
a.sNavText as EName,
' '+a.sNavText as NameDisplay
ContentPageNav as a
a.sNavText + ' >> ' + b.sNavText as Name,
b.sNavText as EName,
|How come queries aren't being added to Django's db.connection.queries in tests?|
| by 02ranger in Databases|
I'm trying to capture the queries which my code submits to the database
by examining the contents of
For some reason though, after all the automatically produced setup queries
are logged, no further queries are logged from my own code. The following
test case demonstrates the behavior.
from django.test import