# Query slower in Servoy than PGAdmin. Why?

**URL:** <https://forum.servoy.com/t/query-slower-in-servoy-than-pgadmin-why/16419>\
**Category:** Classic Servoy\
**Created:** [September 3, 2012, 2:34pm UTC](https://forum.servoy.com/t/query-slower-in-servoy-than-pgadmin-why/16419 "2012-09-03T14:34:27Z")\
**Posts on this page:** 1\
**Page:** 2

<div class="post-metadata">

**Author:** ![rgansevles](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@rgansevles](https://forum.servoy.com/u/rgansevles)\
**Post date:** [September 14, 2012, 10:37am UTC](https://forum.servoy.com/t/query-slower-in-servoy-than-pgadmin-why/16419/21 "2012-09-14T10:37:37Z")

</div>

> david:  
> I suspect that Servoy via the JDBC driver isn’t passing type at all

For custom queries (getDatasetByQuery) we don’t have the type and use PreparedStatement.setObject().  
I guess that the new postgres will base the type on the actual value used and not on wether setString/setTimestamp/etc is called.

For find-queries we do call setTimestamp because we know the type.

Rob

[Previous page](https://forum.servoy.com/t/query-slower-in-servoy-than-pgadmin-why/16419.md?page=1)