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... From what database do you query "select * from table" with ODBC? If you query such a lot of tuples into Sqlite you won't make it better, I think. Also a collection seems to be not very fast. Why not use a mature DB like Postgresql? You could try https://wiki.postgresql.org/wiki/Foreign_data_wrappers If the rows are in Postgres, you can do anything you want. Alles Gute Christof Thalhofer -- Dies ist keine Signatur
signature.asc
Description: OpenPGP digital signature
------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
