Members   Search   Help    Register    Login   Home

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

How to improve the speed of mysql query using count(*) [message #1134] Mon, 23 April 2007 06:32  julian Messages: 13 Registered: March 2007 Junior Member Hi I'm using this kind of queries in mysql in InnoDB engine Select count(*) from marking1 where persondate between '2007-04-23 00:00:00.000' and '2007-04-23 23:59:59.999' and PersonName='aaa' While executing these queries from front end VB, It takes above 5 secs with 50 thousand records. How can I improve speed for this kind of queries. Is there any alternation for this command. Any one knows , Explain thanks Report message to a moderator

	How to improve the speed of mysql query using count(*) By: julian on Mon, 23 April 2007 06:32
	Re: How to improve the speed of mysql query using count(*) By: Gregd on Mon, 30 April 2007 15:15
	Re: How to improve the speed of mysql query using count(*) By: sterin on Mon, 30 April 2007 17:30
	Re: How to improve the speed of mysql query using count(*) By: julian on Wed, 02 May 2007 00:21
	Re: How to improve the speed of mysql query using count(*) By: sterin on Wed, 02 May 2007 06:14
	Re: How to improve the speed of mysql query using count(*) By: julian on Fri, 04 May 2007 01:52
	Re: How to improve the speed of mysql query using count(*) By: sterin on Fri, 04 May 2007 05:12

Previous Topic:	Block user connections
Next Topic:	Lost connection to MySQL server during query

Goto Forum:

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