Count(*) different from .getSize()

Classic Servoy
1

Hi all,

Using servoy 4.1.0 and Sybase.

Does anyone know how the aggregate SQL function Count() could return a different number than .getSize called on a relationship. The relationship is a single key relationship using the same key as in the Where clause: ```
SELECT Count() number_rows WHERE key = ? FROM related_ table


In this case Count(*) returns 95 and relationship.getSize() returns 60.

Thanks,
-Jeremy
2

Hi,

getSize() will only give you the loaded records and Servoy loads records by batch (normal batchsize 200 and in case of a related foundset 60)

use databaseManager.getFoundsetCount to get the total number of records in the foundset.

Regards,

Hans

3

Thanks Hans,

I was aware of the 200 limit, but had never encountered the 60 record limit on related sets.