User Jim Thio - Database Administrators Stack Exchange

bio	website	howtolearnmath.com
	location
	age
visits	member for	1 year, 9 months
	seen	Feb 27 at 3:22
stats	profile views	93

	455 reputation	bio	website	howtolearnmath.com	visits	member for	1 year, 9 months
210 badges		location			seen	Feb 27 at 3:22

2

6

votes

2

answers

786

views

How do Application Like Yelp Retrieve distance information from data base efficiently

jun 21 '12 at 8:12 Jim Thio 455

3

5

votes

3

answers

2

kviews

How to Best Implement nearest neighbour search in mysql?

mysql sql

sep 12 at 16:01 Rick James 1,519

5

votes

2

answers

196

views

Less restrictive query return less result due to simple removing one additional constraint

mysql mysql-5.5 spatial

jun 28 at 14:16 Jim Thio 455

1

4

votes

1

answer

226

views

How does R-Tree outperform B-Tree for simple check if a point is within a rectangle

mysql spatial

oct 21 at 9:21 ypercube 8,714

4

votes

2

answers

275

views

How to speed up this simple mysql query?

mysql

sep 12 at 16:03 Rick James 1,519

4

votes

2

answers

534

views

Is there a way to hint to query optimizer to MySQL which constraints should be done first?

mysql optimization subquery optimizer

aug 8 at 15:30 RolandoMySQLDBA 41.3k

3

votes

1

answer

390

views

Mongo cannot find my collection

mongodb

feb 13 at 9:14 Jim Thio 455

1

3

votes

2

answers

4

kviews

Error: couldn't connect to server 127.0.0.1:27017 src/mongo/shell/mongo.js:91 when changing mongodb data directory

mongodb ubuntu

aug 31 at 2:47 Jim Thio 455

3

votes

2

answers

145

views

Does MongoDB auto compacting

mongodb

aug 24 at 12:58 BryceAtNetwork23 1,291

1

3

votes

1

answer

1

kviews

Mongodb - Returning the points nearest to a location, with distance

mysql mongodb php

aug 21 at 12:12 Adam C 1,348

3

votes

0

answers

162

views

Can spatial index be a part of multiple columns index in mysql?

index

aug 19 at 16:51 Jim Thio 455

3

votes

2

answers

306

views

Why innodb doesn't store geospatial data?

myisam

jun 14 '12 at 13:39 Remus Rusanu 20.9k

2

votes

2

answers

160

views

Is there an easy way to copy one database to another

mysql

dec 14 at 14:25 khaled_webdev 111

2

votes

2

answers

361

views

How does compound index help speed up query?

mysql index query-performance

aug 7 at 16:42 Jon Seigel 6,903

1

vote

2

answers

445

views

How do I get spatial index feature if I mainly use innodb?

mysql innodb myisam spatial

feb 26 at 3:11 Community♦ 1

1

vote

1

answer

667

views

How to display query result in rockmongo by using execute method

mongodb rockmongo

feb 25 at 3:32 Jim Thio 455

1

vote

1

answer

384

views

Does MySQL have a limitation of one index per query?

mysql index

jan 5 at 18:51 Community♦ 1

1

vote

1

answer

164

views

How to interpret this “db.explain()” for this mongodb query

index mongodb

nov 4 at 9:58 Community♦ 1

1

vote

1

answer

280

views

$nearSphere returns too many data. What am I missing? Am I wrong? Is it a bug? Does other see the same thing?

mongodb spatial

sep 25 at 18:17 Max Vernon 4,196

1

vote

1

answer

27

views

Can we use innodb to store latitutude and logitude and retrieve 20 closest points well?

innodb

sep 12 at 0:52 Rick James 1,519

1

vote

1

answer

95

views

What's the fastest way to replicate data?

mongodb

aug 24 at 8:15 Adam C 1,348

1

vote

2

answers

326

views

Where can I get this nice phpMyadmin features for mongodb

mongodb rockmongo

aug 21 at 7:30 Jim Thio 455

1

vote

1

answer

258

views

How to add spatial indexes through rockmongo

mongodb rockmongo

aug 14 at 15:50 Adam C 1,348

1

vote

1

answer

327

views

How to handle temporary tables with mutliple connections?

mysql temp-tables

aug 7 at 10:41 Shlomi Noach 2,050

1

vote

0

answers

142

views

How to speed up this query

mysql-5 mysql-5.5 myisam

jul 29 at 23:51 Community♦ 1

1

vote

0

answers

86

views

Why do we need myisam spatial extension anyway?

mysql myisam spatial

jun 21 '12 at 7:56 Jim Thio 455

1

vote

1

answer

133

views

What is the SQL command to get 20 closest points from some center location

mysql myisam spatial

jun 20 '12 at 22:16 Rick James 1,519

1

0

votes

1

answer

70

views

Why number of matches in fulltext search get less when we put less strings?

mysql myisam full-text-search

feb 18 at 13:33 rubo77 236

0

votes

1

answer

33

views

How to save mongodb data sub data more properly in this case?

mongodb

jan 4 at 18:41 Anass 16

0

votes

1

answer

663

views

Can we back up mysql databases by copying files?

mysql backup installation

nov 9 at 15:37 Community♦ 1

Jim Thio

52 Questions