2017-07-01 10:59 GMT-04:30 Christof Thalhofer <chri...@deganius.de>: > From what database do you query "select * from table" with ODBC? > sybase and Oracle, a propietary odbc module does all the job very good, but i need to use open source,, and freetds have in combination with gambas lack of a good cursor.. the cursor are foward only, and some things like record counts from select does not are.. in the oracle way its more complicated
> > 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. > tested, very slower... you have right.. sqlite memory more faster but still slow process passed to sqlite from remote db > > Why not use a mature DB like Postgresql? You could try > so madure, so good, but not so enterprise, mayor vendors and software bussines works only with SAP sybase and BI oracle so if the couple of software to implement does not connect to these database, then not exits. > 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 > > > > ------------------------------------------------------------ > ------------------ > 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
