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 <[hidden email]> 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