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