[Gambas-user] any way to convert Result to Collection more faster than copy?

[Christof Thalhofer]

Am 01.07.2017 um 12:35 schrieb PICCORO McKAY Lenz:
> hi cristof, the query its just "select * from table" but where
> "table" its a "cube" of the datawarehouse.. so i want to made a
> something similar to BussinesObject.. so get 200.000 rows its not a
> surprise in desktop..

For a datawarehouse 200.000 rows are not very much. But in a
datawarehouse normally those jobs are running at night. Next day you
look at the results and you get them fast, because these are just a
handful of tuples(records) or there is nothing to be extracted.

> the other problem to force me to get so many rows its the lack of 
> features/connectivity to large scalar DBMS such like DB2, ASE sybase
> or Oracle.. so i must et all the rows firts to later operate in the
> client side, this in any case its better due avoit goin to db on each
> "change" of filters...