SelectCompiled from Native-Select - add method size()

[maw2be]

ArcadeDB Version:

24.6.2

OS and JDK Version:

JDK21

Expected behavior

add to Native-select for SelectCompiled method size()? currently to get size (for example for "if (size != 0){} need to do something like
Integer size = result.vertices().toList().size();

[robfrank]

The SelectCompiled is not yet executed, that's why a size() method is not present.
When selectCompiled.vertices() is called, the query is executed and and at that point you can call toList().size()

[lvca]

If you only need the count, please evaluate using SQL instead: select count(*) from .... It's faster and requires way less RAM. With .toList() ArcadeDB allocates in RAM the whole resultset in a Java List. This could be very expensive, based on the number of records. The SQL count, instead, just counts the records without keeping them in RAM.

[maw2be]

If you only need the count, please evaluate using SQL instead: select count(*) from .... It's faster and requires way less RAM. With .toList() ArcadeDB allocates in RAM the whole resultset in a Java List. This could be very expensive, based on the number of records. The SQL count, instead, just counts the records without keeping them in RAM.

Yes, using sql is one of the option. what I was thinking that this sql will be build and execute on db side, then I don't have to do this. It's all about simplicity.