Search

Clear filter
Article
Corentin Blondeau · Feb 24

Introducing UDP Adapter

the reviver side, according to the index.
Article
Muhammad Waseem · Feb 10, 2023

Getting to know Python Flask Web Framework - Part 2

(): #to render main index page return render_template('index.html') @app.route("/processes") def processes(): #Define sql statement mySql = ''' SELECT
Article
Pietro Di Leo · Oct 6

Presenting IRIS Tool and Data Manager: Integrating InterSystems IRIS with Python, Pandas, and Streamlit

x2194; IRIS Table Conversion with automatic type inference CRUD operations and SQL view creation Schema exploration and metadata inspection Support for standard and HNSW vector indexes
Question
Francis Galiegue · Apr 13, 2016

Followup on the unconference session about unit test and code coverage: it may be doable after all... But I need help

Timings are indeed irrelevant.The plan is to run unit tests with coverage activated, scan both the test results and monitoring results and collect the results.
Article
Luis Angel Pérez Ramos · Mar 17

Having trouble connecting your Visual Studio Code to your IRIS instance via WebGateway? Here are some tips!

Indeed, the app is not enabled. To change this, go to its settings by clicking on its name, then select Enabled App. With that activation the problem should be solved.
Question
Kevin Furze · Sep 13, 2017

is there a reverse version of $listNext ?

$ListGet(tInputList,i) // Do something with tValue } ``` You could use something like the following (which accounts for null values in the $ListBuild list by skipping that index
Question
Arpitha Ramakrishnaiah · May 11, 2017

Compare and update two directories\namespaces for class files

It contains the class definition of all classes : methods, properties, indexes, storage etc. are all in this global.
Question
Stella Ticker · May 12, 2017

Using multiple processes to process a single file

If this is not indexed or tuned then you will have some serious IO thrashing going on, and no matter how many cores you throw at the problem, you will not get any overall performance
Question
Steve Riddle · Nov 9, 2020

Apache RewriteRule on IRIS

csp" ErrorLog ${APACHE_LOG_DIR}/error.log CustomLog ${APACHE_LOG_DIR}/access.log combined LogLevel info <Directory /intersystems/irissys/csp/test> Options Indexes
Question
Paul Mathieson · Oct 26, 2016

Data extraction using SQL Via ODBC

KEY=GSQLOPT_opttablePlay particular attention to the section about using TuneTable to properly set the meta-data around table extent size, selectivity, etc.
Question
Token Ibragimov · Feb 22, 2019

how to convert JSON to object in cache 2010 version

access_token") = "4SDFDSFDSF-aSDASDASD" |%data("expires_in") = 3300 |%data("refresh_token") = "" | %data("scope") = "sms_send" |%data("token_type") = "Bearer" | %index
Question
Matthias Ruckenbauer · Aug 29, 2019

linked table (ODBC), %New() -> %Save()

This has been considered in the setup and the generated class has an Index MainIndex On id [ IdKey ]; which looks fine to me.
Question
Goran Stefanovic · Dec 12, 2018

GROUP BY causes NativeError: [10053]

field2 from GCT.PA_Data where field1 is not null and ID between 1 and 100000) group by field1This is not the final solution but a way to understand the limits of your server.BTW:an index
Question
Nicola Sartore · Nov 5, 2021

Iterate over an SQL result set

%GetData(1) } // Reset cursor index. While (result.%Previous() > 0) { // Do nothing. } // Show get column data again. While (result.%Next()) { Wrtie result.
Question
Jim Cooper · Oct 14, 2024

Using Cache, Python and pypyodbc, struggling dates

= list(row) # copy rows to list for date_col in date_cols: # for each date column index