Opened 3 months ago

Closed 3 months ago

Last modified 11 days ago

#28518 closed Cleanup/optimization (fixed)

improve performance of loading geometries from DB

Reported by: Sergey Fedoseev Owned by: Sergey Fedoseev
Component: GIS Version: master
Severity: Normal Keywords:
Cc: Triage Stage: Accepted
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: yes
Easy pickings: no UI/UX: no

Description


Change History (10)

comment:1 Changed 3 months ago by Sergey Fedoseev

Owner: changed from nobody to Sergey Fedoseev
Status: newassigned

comment:2 Changed 3 months ago by Sergey Fedoseev

PR

Before:

In [2]: %timeit for x in City.objects.values_list('point')[:1000]: pass
64.4 ms ± 644 µs per loop (mean ± std. dev. of 7 runs, 10 loops each)

After:

In [3]: %timeit for x in City.objects.values_list('point')[:1000]: pass
49.8 ms ± 957 µs per loop (mean ± std. dev. of 7 runs, 10 loops each)

comment:3 Changed 3 months ago by Tim Graham

Has patch: set
Patch needs improvement: set
Triage Stage: UnreviewedAccepted

comment:4 Changed 3 months ago by Tim Graham <timograham@…>

Resolution: fixed
Status: assignedclosed

In 1a85b07:

Fixed #28518 -- Improved performance of loading geometries from DB.

comment:5 Changed 3 months ago by Sergey Fedoseev

another PR

Before:

In [3]: %timeit for x in City.objects.values_list('point')[:1000]: pass
49.5 ms ± 367 µs per loop (mean ± std. dev. of 7 runs, 10 loops each)

After:

In [4]: %timeit for x in City.objects.values_list('point')[:1000]: pass
32.1 ms ± 1.54 ms per loop (mean ± std. dev. of 7 runs, 10 loops each)

comment:6 Changed 2 months ago by Tim Graham <timograham@…>

In 2ef4b479:

Refs #28518 -- Improved performance of loading geometries from DB.

comment:7 Changed 2 weeks ago by Tim Graham <timograham@…>

In 8869142a:

Fixed #28632 -- Updated docs about using raw SQL with GIS and doc'd changes from refs #28518 in release notes.

comment:8 Changed 2 weeks ago by Tim Graham <timograham@…>

In a44fb4aa:

[2.0.x] Fixed #28632 -- Updated docs about using raw SQL with GIS and doc'd changes from refs #28518 in release notes.

Backport of 8869142a4d5b069c61781c0e4c5fdc971b017949 from master

comment:9 Changed 12 days ago by Sergey Fedoseev

PR

Before:

In [2]: %timeit for x in City.objects.all()[:1000]: pass
106 ms ± 802 µs per loop (mean ± std. dev. of 7 runs, 10 loops each)

After:

In [2]: %timeit for x in City.objects.all()[:1000]: pass
81.8 ms ± 595 µs per loop (mean ± std. dev. of 7 runs, 10 loops each)

comment:10 Changed 11 days ago by Tim Graham <timograham@…>

In a4f9ef4:

Refs #28518 -- Improved performance of assigning values to GeometryFields.

Note: See TracTickets for help on using tickets.
Back to Top