Members   Search   Help    Register    Login   Home

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

Map bounding box.. [message #517] Mon, 01 January 2007 13:50  oordopjes Messages: 15 Registered: January 2007 Junior Member Hi, I would really like any suggestions on the following concerning performance..: I have 1.000.000 locations with: - a name - a latitude - a longitude - a score I want to: - select all locations on a particular (google)map. So a latitude BETWEEN (.. AND ..) AND longitude BETWEEN (.. AND ..) - fulltext match name. So name MATCHES (..) - ORDER BY score How would I get the best performance? What indexes should I create? Should I split the data in two tables and then JOIN? Or should I put everything together in one table? ANY help would be great!! Report message to a moderator

	Map bounding box.. By: oordopjes on Mon, 01 January 2007 13:50
	Re: Map bounding box.. By: Peter on Mon, 01 January 2007 14:47
	Re: Map bounding box.. By: oordopjes on Mon, 01 January 2007 18:10
	Re: Map bounding box.. By: oordopjes on Mon, 01 January 2007 18:20
	Re: Map bounding box.. By: Peter on Tue, 02 January 2007 10:10
	Re: Map bounding box.. By: oordopjes on Tue, 02 January 2007 17:18
	Re: Map bounding box.. By: Peter on Tue, 02 January 2007 17:28
	Re: Map bounding box.. By: oordopjes on Wed, 03 January 2007 18:20
	Re: Map bounding box.. By: Peter on Wed, 03 January 2007 18:40
	Re: Map bounding box.. By: bluesaga on Thu, 04 January 2007 06:04
	Re: Map bounding box.. By: oordopjes on Thu, 04 January 2007 06:18
	Re: Map bounding box.. By: bluesaga on Thu, 04 January 2007 06:24
	Re: Map bounding box.. By: Peter on Thu, 04 January 2007 06:58
	Re: Map bounding box.. By: oordopjes on Thu, 04 January 2007 07:14
	Re: Map bounding box.. By: Peter on Thu, 04 January 2007 07:27
	Re: Map bounding box.. By: oordopjes on Fri, 02 February 2007 05:11
	Re: Map bounding box.. By: Peter on Fri, 02 February 2007 06:51

Previous Topic:	mysql not using index
Next Topic:	can't open .ibd file error

Goto Forum:

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