Article Jean Millette · Dec 9, 2023 3m read Working Around SOAP Service Timeouts Some of our applications provide SOAP services that use “DSTIME”-based SQL queries that return records that have recently been added or changed. Since the records don’t change often, these queries usually return a small number of records and therefore take little time. #InterSystems IRIS 4 0 0 155
Article Jean Millette · Oct 26, 2022 6m read The Name Game: Using a Popular Song as Spec for Introductory ObjectScript/Python Project TL;DR: This article describes an introductory-level project that exercises some string-manipulation functions in both ObjectScript and Python…with specs from a song. #Embedded Python #ObjectScript #InterSystems IRIS 8 3 0 268
Article Jean Millette · Nov 5, 2021 2m read The Importance of ‘set Row = “”’ in Class Query “Fetch” Method One of our apps uses a class query to support a ZEN Report and works just fine in that report, producing the expected results every time. We’ve since migrated to InterSystems Reports and noticed that, for a report using the same class query, 100s of extra rows with the same column values appear at its bottom. #InterSystems Reports #JDBC #ODBC #SQL #Tips & Tricks #InterSystems IRIS 3 0 0 293
Article Jean Millette · Nov 2, 2019 15m read Workaround for “hidden” Column Problem in ZEN dataGrid Component The Issue #UI Development #ZEN #Caché #Ensemble 3 0 0 327
Article Jean Millette · Aug 22, 2019 3m read A Case for Thawing Frozen Query Plans After Upgrade Our team is reworking an application to use REST services that use the same database as our current ZEN application. One of the new REST endpoints uses a query that ran very slowly when first implemented. After some analysis, we found that an index on one of the fields in the table greatly improved performance (a query that took 35 seconds was now taking a fraction of a second). #Indexing #Performance #SQL #Caché #InterSystems IRIS 3 4 0 413