Hi!
Have you checked that the query is escaped correctly? All single quotes
(') needs to be escaped with another single quote, but that has been for
MS-SQL all the time so I'll doubt that the problem is escaping.
Another issue I noticed is that SQL Server 2005 handles SMALLDATETIME
coulmns
Krister -
I've included the query below - If I paste it in query analyzer on 2000, or
2005 it works fine.
Just coming through PHP4 to 2005, it hangs. I actually don't get an error, and
then the browser says the server is too busy to handle the request. Strange
things like that. (I am using
Ouch! That was like the.. longest.. query that I've ever seen! I'm
surprised that it actually works and even more impressed that someone
actually figured that out... It might take a long time to run, since it
uses so many subqueries (if there's lots of data or even a moderate
amount of data).
Been getting the occasional warning on one of our client sites about
excessive CPU usage and/or slow MySQL queries.
Looking at the logs, it looks like it's more the latter (slow queries).
Some of the queries involve some joins, etc. But nothing too crazy, and
there are the standard indexes on
UPDATE jos_content SET hits = ( hits + 1 ) WHERE id='123'
The log says this took 7 seconds. There's an index on id. There are only
400 or so records in the whole table. It's not like there are a million
records and no index.
Is there ANY rational reason this query would EVER take 7
Thanks for the response, Chris. I have analyzed, optimized, checked, etc.
Everything looks relatively good/healthy on the server side of things. It
is MyISAM. That's one thing I don't really know very well, the benefits of
the different DB engines.
Not sure if I'm going to be able to see a
TG wrote:
Thanks for the response, Chris. I have analyzed, optimized, checked, etc.
Everything looks relatively good/healthy on the server side of things. It
is MyISAM. That's one thing I don't really know very well, the benefits of
the different DB engines.
Not sure if I'm going to be
TG wrote:
Been getting the occasional warning on one of our client sites about
excessive CPU usage and/or slow MySQL queries.
Looking at the logs, it looks like it's more the latter (slow queries).
Some of the queries involve some joins, etc. But nothing too crazy, and
there are the
- Original Message -
From: Afan Pasalic [EMAIL PROTECTED]
To: TG [EMAIL PROTECTED]
Cc: php-db@lists.php.net
Date: Wed, 05 Nov 2008 17:07:46 -0600
Subject: Re: [PHP-DB] Joomla MySQL query performance affected by anything
non-server related?
TG wrote:
Been getting the occasional
TG wrote:
- Original Message -
From: Afan Pasalic [EMAIL PROTECTED]
To: TG [EMAIL PROTECTED]
Cc: php-db@lists.php.net
Date: Wed, 05 Nov 2008 17:07:46 -0600
Subject: Re: [PHP-DB] Joomla MySQL query performance affected by anything
non-server related?
TG wrote:
Been getting
10 matches
Mail list logo