Project

General

Profile

Issue #84

Feature #1432: latitude and longtitude based

search algorithm is too slow, 1500+ ms per task in 300,000 rows in average. Solved by adding index to lantitude and longtitude.

Added by Tab Tu about 6 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Tab Tu
Start date:
2019-08-27
Due date:
2019-09-01
% Done:

100%

Estimated time:
Spent time:
20.00 h

Description

basic search in database or entities.
After add index to lantitude and longtitude, the average time is 200+ ms.

#1

Updated by Tab Tu about 6 years ago

  • Status changed from New to Closed
  • % Done changed from 0 to 100
#2

Updated by Tab Tu about 6 years ago

  • Parent task set to #1432
#3

Updated by Tab Tu about 6 years ago

  • Due date changed from 2019-09-05 to 2019-09-01
  • Start date changed from 2019-09-03 to 2019-08-27
#4

Updated by Tab Tu about 6 years ago

  • Assignee set to Tab Tu

Also available in: Atom PDF