In a maintenance project that it's working with IBM Informix Dynamic Server Version 11.50.FC6 we have to improve the performance of some queries. One of this queries to the Informix DB fetches a LVARCHAR datatype column and it takes too long.
I've also tried the same query with different programs (DbVisualizer, DBeaver) and I've found the same problem that in my aplication. However, I've tried Server Studio and the same query is instant, so I gather that the database is not the problem.
I would like to know why Server Studio works so good. And how to copy its behaviour in my application, with JDBCTemplate.