Devart Forums

hi..

Table BCMT510 RecountCount : 626,530 records

OraQuery component set is
Options.QueryRecCount := True;
FetchAll := False;
FetchRows := 100;

and..

SELECT * FROM BCMT510;

result time is very long time..

I want this.
1. fast open 100 rows.
2. if pagedown key then next 100 rows. again, again, again..

how to????
thanks read..

As far as i know is QueryRecCount the problem.

It first does a SELECT COUNT(*) FROM BCMT510

Greetings
Jens

jfudickar wrote:As far as i know is QueryRecCount the problem.

It first does a SELECT COUNT(*) FROM BCMT510

Greetings
Jens

But Ver 5.80 it was faster than ver 6 even in the insert and update statements

Regards
Bahry

To speed up the query opening, set QueryRecCount to False.

We could not reproduce the problem with the performance of insert and update statements. Please send to odac*devart*com a complete small sample that demonstrates the problem, including the script for creating database objects.