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.t...@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 > > > > > > >
