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

[PICCORO McKAY Lenz]

2017-07-01 10:59 GMT-04:30 Christof Thalhofer <chrisml at ...3340...>:

> 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 at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>
>