Partial data fetching in servoy

Questions and answers on designing your Servoy solutions, database modelling and other 'how do I do this' that don't fit in any of the other categories

Partial data fetching in servoy

Postby dekumar2 » Fri May 12, 2017 11:50 am

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.
dekumar2
 
Posts: 8
Joined: Thu May 11, 2017 6:59 am

Re: Partial data fetching in servoy

Postby ROCLASI » Fri May 12, 2017 12:00 pm

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.
Robert Ivens
ROCLASI Software Solutions / JBS Group, Partner
SAN Developer / Servoy Valued Professional / Servoy Certified Developer
Twitter: @roclasi / @servoyforge
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5205
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: Partial data fetching in servoy

Postby Bernd.N » Fri May 12, 2017 12:56 pm

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 Korthaus
LinkedIn
Servoy 7.4.9 SC postgreSQL 9.4.11 Windows 10 Pro
User avatar
Bernd.N
 
Posts: 474
Joined: Mon Oct 21, 2013 5:57 pm
Location: Langenhorn, North Friesland, Germany

Re: Partial data fetching in servoy

Postby Bernd.N » Mon May 15, 2017 4:36 pm

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.
Bernd Korthaus
LinkedIn
Servoy 7.4.9 SC postgreSQL 9.4.11 Windows 10 Pro
User avatar
Bernd.N
 
Posts: 474
Joined: Mon Oct 21, 2013 5:57 pm
Location: Langenhorn, North Friesland, Germany


Return to Programming with Servoy

Who is online

Users browsing this forum: No registered users and 4 guests