How to speed query open?

snap7i · Post by **snap7i** » Tue 08 Jul 2008 10:01

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

jfudickar · Post by **jfudickar** » Tue 08 Jul 2008 11:42

As far as i know is QueryRecCount the problem.

It first does a SELECT COUNT(*) FROM BCMT510

Greetings
Jens

bahry · Post by **bahry** » Tue 08 Jul 2008 16:21

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

Plash · Post by **Plash** » Fri 11 Jul 2008 07:28

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.