# Very slow queries in the Geo JSON generation using cursors

**URL:** <https://forums.percona.com/t/very-slow-queries-in-the-geo-json-generation-using-cursors/5633>\
**Category:** Other MySQL® Questions\
**Created:** [May 23, 2017, 1:28pm UTC](https://forums.percona.com/t/very-slow-queries-in-the-geo-json-generation-using-cursors/5633 "2017-05-23T13:28:23Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Diego\_Mozqueda](https://avatars.discourse-cdn.com/v4/letter/d/c77e96/32.png) [@Diego\_Mozqueda](https://forums.percona.com/u/Diego_Mozqueda)\
**Post date:** [May 23, 2017, 1:28pm UTC](https://forums.percona.com/t/very-slow-queries-in-the-geo-json-generation-using-cursors/5633/1 "2017-05-23T13:28:23Z")

</div>

Hi good day, I would like to ask your support in the revision of the cursor that I am using for the construction of a geo json that from certain records is taking a long time to generate, I would like to know if there is any other function or process for the construction of the Geo json other than cursors.

[sp\_get\_estructura.txt](https://forums.percona.com/uploads/short-url/ubkkc5qT61WOYEGGNZLv5yTSXm4.txt) (1.72 KB)