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..
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... in any case, seems the better approach its usage of in-memory sqlite db.. and for the 30 minutes in my case seems its something on the gambas installation.. but debug and thenn report a bug its quite complicated for me right now.. im focused in odbc+handle data for now Lenz McKAY Gerardo (PICCORO) http://qgqlochekone.blogspot.com 2017-07-01 5:32 GMT-04:30 Christof Thalhofer <chri...@deganius.de>: > Am 30.06.2017 um 00:57 schrieb PICCORO McKAY Lenz: > > > i'm taking about 200.000 rows in a result... the problem its that the > odbc > > db object support only cursor with forward only.. > > Show us your query. For what do you need 200.000 rows? That's way too > much if you want to visialize anything. > > > Alles Gute > > Christof Thalhofer > > -- > Dies ist keine Signatur > > > ------------------------------------------------------------ > ------------------ > 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 > > ------------------------------------------------------------------------------ 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
