Re: Generate class hierarchy from JSON Schema
Posted by
eftomi on
Mar 11, 2020; 6:02pm
URL: https://forum.world.st/Generate-class-hierarchy-from-JSON-Schema-tp5110239p5113261.html
Hi Esteban,
Thanks for reporting this issue. I haven't made any "stress" tests yet for ADOClient. Could you please try to use ADORecordset as described in the readme? There you have a direct access to each record at a time, and then you can create your own "loop" to process the query result. In this way you can avoid the loop in ADOClient>>query: method.
Best wishes,
Tomaz
------ Original Message ------
Sent: 11. 03. 2020 18:25:51
Subject: Re: [Pharo-users] Generate class hierarchy from JSON Schema
As an additional reference, I attach the profile tally for the query I'm mentioning.
The culprit seems to be the calculation of the ADOField properties that might be calculated on every call.
On Wed, Mar 11, 2020 at 2:13 PM Esteban Maringolo <
[hidden email]> wrote:
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,
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