Members   Search   Help    Register    Login   Home

Show: Today's Messages  :: Show Polls :: Message Navigator

Queries locking the database [message #139] Wed, 06 September 2006 06:42  geelwortel Messages: 25 Registered: September 2006 Junior Member After a HUGE performance loss on MySQL version 5 we moved back to version 3. The main problem we have now is that one of the queries are locking the database every time it is running. The query is: Select count(*) as NoRec from gen_Main Left Join con_History ON (gen_Main.WKey = con_History.WKey) Where con_History.RecActive = 'y' And con_History.MOID = 1 And con_History.DepId =14 Can someone please help Report message to a moderator

	Queries locking the database By: geelwortel on Wed, 06 September 2006 06:42
	Re: Queries locking the database By: Peter on Wed, 06 September 2006 06:46
	Re: Queries locking the database By: geelwortel on Wed, 06 September 2006 07:00
	Re: Queries locking the database By: Peter on Wed, 06 September 2006 07:11
	Re: Queries locking the database By: spud on Thu, 19 October 2006 21:28
	Re: Queries locking the database By: geelwortel on Wed, 25 October 2006 04:24
	Re: Queries locking the database By: Peter on Wed, 25 October 2006 04:48
	Re: Queries locking the database By: geelwortel on Wed, 25 October 2006 06:06
	Re: Queries locking the database By: Peter on Wed, 25 October 2006 09:58
	Re: Queries locking the database By: geelwortel on Thu, 26 October 2006 01:55
	Re: Queries locking the database By: Peter on Thu, 26 October 2006 09:54
	Re: Queries locking the database By: geelwortel on Thu, 26 October 2006 11:06

Previous Topic:	performance of query for normalized DB
Next Topic:	Order of columns in indexes

Goto Forum:

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]