Fetch data on demand

[chris901]

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?

[Shalex]

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).