Partial data fetching in servoy

[dekumar2]

Hi all, I am new to servoy, I have a table having 109 columns we want to fetch only 10 columns for reducing processing time. is it possible? if yes, then please help me.

[ROCLASI]

Sorry dekumar,

Why do you keep cross posting?
I am in fact answering your question in the original thread.
There is no need to post the same question in multiple places. Users can see your post wherever you place it in the Active Posts overview.

[Bernd.N]

The normal fetching mechanism in Servoy is that all columns are loaded, but not all rows. Instead only a number like 200 rows are loaded, and then more when they are needed. That is how Servoy will reduce processing time.

What are you going to do with the 10 columns? Show them to the user?
Usually the Servoy mechanism is very fast and there is no need to reduce columns.
We have a table with more than 200 columns/fields and showing that table in a table form is fast.

[Bernd.N]

On the other hand, there are datasets where you can fetch a reduced number of columns.
https://wiki.servoy.com/display/public/DOCS/Database+Manager#DatabaseManager-getDataSetByQuery(server_name,sql_query,arguments,max_returned_rows)

But it depends what you want to do.
Fastest way to change data is direct SQL, if it is possible to use that.