TSmartQuery [Get RecCount]

renez · Post by **renez** » Thu 06 Dec 2007 12:13

Hello!

Is there an other possibility to call GetRecCount, than the property Options.QueryRecCount?

Thanks.

Plash · Post by **Plash** » Mon 10 Dec 2007 08:48

You can manually execute query to get record count:

OraQuery2.SQL.Text := 'SELECT count(*) FROM (' + OraQuery1.SQL.Text + ')';
OraQuery2.Open;

renez · Post by **renez** » Mon 10 Dec 2007 09:35

Thanks for your answer.
My problem is, that we have a program which is coded by a outside company and i cannot find the part where GetRecCount is called. QueryRecCount is false and there is no count(*) in the code. But when i start the program, i can always see GetRecCount in the debug window. The count(*) needs roundabout 30 seconds, because of very much data in the table. So it takes a long time till the program is open to use.
Therefore i ask, if there is an another way to call GetRecCount.

Plash · Post by **Plash** » Mon 10 Dec 2007 11:55

There is no another way to call GetRecCount.

renez · Post by **renez** » Mon 10 Dec 2007 11:58

OK, thanks.

[email protected] · Post by **[email protected]** » Thu 13 Dec 2007 10:26

Code: Select all

Select count(0) from ....

is much faster that count(*)

jfudickar · Post by **jfudickar** » Thu 13 Dec 2007 10:46

I use

Code: Select all

select count(1)

But prinziple you are right !

Greetings
Jens