Fetch data on demand

Fetch data on demand

Postby chris901 » Thu 08 Sep 2016 17:26

Hello,

I am creating a test case table like this:

create table MuchData
(
MuchDataId serial,
string1 varchar(500),
string2 varchar(500),
string3 varchar(500),
string4 varchar(500),
string5 varchar(500),
string6 varchar(500),
string7 varchar(500),
string8 varchar(500),
string9 varchar(500),
string10 varchar(500),

primary key (MuchDataId)
)

and fill it with 1+ million rows


insert into MuchData
(string1,
string2,
string3,
string4,
string5,
string6,
string7,
string8,
string9,
string10)
select md5(random()::text) from generate_Series(1, 1000000) s;


When loading the data it takes very long (1+ minutes).

Thats understandable because it's a lot of data.

However in the PgSqlData settings I defined FetchAll = False.

Hot can i load data on demand and reduce the long waiting time?
chris901
 
Posts: 64
Joined: Wed 20 Jul 2016 04:21

Re: Fetch data on demand

Postby Shalex » Tue 13 Sep 2016 15:44

If FetchAll=false, the number of rows fetched from database is determined by the DataGrid control the PgSqlDataTable instance is bound to.

You can check the current number of fetched records via RecordCount properties of your PgSqlDataTable (if QueryRecordCount=false).
Shalex
Devart Team
 
Posts: 7774
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for PostgreSQL