# No limit in Servoy sql query

**URL:** <https://forum.servoy.com/t/no-limit-in-servoy-sql-query/20377>\
**Category:** Questions\
**Created:** [November 23, 2020, 8:04am UTC](https://forum.servoy.com/t/no-limit-in-servoy-sql-query/20377 "2020-11-23T08:04:58Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![lwjwillemsen](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/lwjwillemsen/32/4987_2.png) [@lwjwillemsen](https://forum.servoy.com/u/lwjwillemsen)\
**Post date:** [November 23, 2020, 8:04am UTC](https://forum.servoy.com/t/no-limit-in-servoy-sql-query/20377/1 "2020-11-23T08:04:58Z")

</div>

Hi,

After end user performance reports we observe for **some**  **_form_** foundsets that there is **no** limit ? in the sql query that Servoy produces.  
I think it has something to do with the sort.  
Below an example taken from the Servoy Admin Page (query type = Load Foundset):

select ord\_sales\_allocation.ord\_sales\_allocation\_id from ord\_sales\_allocation ord\_sales\_allocation  
left outer join ord\_sales\_product\_component ord\_sales\_product\_component on ord\_sales\_allocation.ord\_sales\_allocation\_id=ord\_sales\_product\_component.ord\_sales\_allocation\_id and ord\_sales\_product\_component.owner\_id = ?  
left outer join ord\_sales\_allocation ord\_sales\_allocation1 on ord\_sales\_product\_component.ord\_sales\_allocation\_id=ord\_sales\_allocation1.ord\_sales\_allocation\_id and ord\_sales\_allocation1.owner\_id = ?  
left outer join ord\_sales\_order\_detail ord\_sales\_order\_detail on ord\_sales\_allocation1.ord\_sales\_order\_detail\_id=ord\_sales\_order\_detail.ord\_sales\_order\_detail\_id and ord\_sales\_order\_detail.owner\_id = ?  
left outer join ord\_sales\_order ord\_sales\_order on ord\_sales\_order\_detail.ord\_sales\_order\_id=ord\_sales\_order.ord\_sales\_order\_id and ord\_sales\_order.owner\_id = ?  
left outer join art\_article art\_article on ord\_sales\_allocation.art\_article\_id=art\_article.art\_article\_id and art\_article.owner\_id = ?  
where ord\_sales\_allocation.ord\_sales\_product\_component\_id \> ? and ord\_sales\_allocation.owner\_id = ?  
order by ord\_sales\_order.order\_dt desc, art\_article.sequence\_text asc, ord\_sales\_allocation.ord\_sales\_allocation\_id asc

Seen in Smart Client Servoy 7 and Servoy 2020.03.2

How do I get my limit ? back ?