Hi, To feed a Pharo app I need to read from an old MDB file, via ODBC. So I tested PharoADO and, after adding a missing Variant Type [1], I got my query working (at least read only). However the time of ADOClient to return a query with 10K rows of 5 columns each is extremely slow (+65000ms) compared, e.g., with Dolphin Smalltalk via ODBC (62ms). The time of the execute call to return is instantaneous, so I think the issue might be in the creation of the result set. Is this a known issue? Should I check something else? Thanks in advance, [1] https://github.com/tesonep/pharo-com/pull/10 Esteban A. Maringolo On Fri, Jan 24, 2020 at 5:59 AM Tomaž Turk <tomaz.turk@ef.uni-lj.si> wrote:
That would be amazing!
I'm a Mac/Unix guy so I don't have access to the other platforms (I suppose I could fire up an AWS Oracle). I can do mysql/mariadb, posgresql, and sqlite.
I'm pretty close to pushing my ActiveRecord extensions. I just need to get many to many with link tables done and it is good to go. I spent a few days "porting" the ruby inflector and its tests.
As for database introspection, I am relying on this new method and the result set format on DatabasePlatform.
printSqlStatementToListColumnsInTable: aDatabaseTable inSchema: schemaString on: aStream " Format: name | type | length | nullable | default_value | pk
-------------------------+-------------------+--------+----------+-----------------------+---- id | character varying | 255 | 0 | ''::character varying | 1
This is great news about ActiveRecord!
ADO is, unfortunately, a Windows library, so PharoADO is limited to Windows. Maybe as a next step we should focus into Garage and the addition of SQL Server and Oracle support. If I only had time ...
Stéphane, thanks for the support.
Best wishes, Tomaz