go to post Guillaume Rongier · Jan 22, 2019 My guess is that you are concatenating string with the operator "&" (AND) instead of "_".If you do so, ObjectScript will cast your string as boolean false, the result of (false and false and false) equals 0, the result you see in your question. Method PatientInfo(ID As %String) As %Status { #dim status as %Status=$$$OK SET myquery="SELECT GUID, IDType,IDValue FROM MergeHyland.TypeTwoDimesionCollection WHERE GUID ="_ID SET rset=##class(%ResultSet.SQL).%Prepare(myquery,.err,"") WHILE rset.%Next() { WRITE !,rset.GUID _ ":" _ rset.IDType_ ":" _ rset.IDValue } WRITE "End of data" return status }
go to post Guillaume Rongier · Jan 22, 2019 Hi Benjamin,In some cases we have to use Ensemble as an ETL not an ESB.So we extract lot of data, transform and load them throw the JDBC SQL Adapter in EnsLib. To do so, we dont do it line by line throw messages but ResultSet by ResultSet (one ResultSet can have more than 500 000 lines and 30 colones). This pattern work well.But we have start to have time treatment issue. Our process took more than 8 hours. When we analyze it, what it cost time is the select and insert treatment.We solved the problem of select treatment with this post : https://community.intersystems.com/post/jdbc-large-query-optimisationSo now, we are looking for a way to improve insert time. Our guess is to implement throw JDBC SQL Adapter in EnsLib the java pattern with PrepareStatement.addBatch() then executeBatch().Do you have any idea to improve the insert treatment ?
go to post Guillaume Rongier · Jan 7, 2019 Hi Eduardo,My comprehension of your use of Git and Ensemble is that all devs build on the same sever like this :This is not the way to go.I recommend to use this model where every devs have there own server :
go to post Guillaume Rongier · Sep 20, 2018 Hi Marc, I'm intereded by your sample code for this kind of optimisation even if we have to use a different EnsLib.SQL.GatewayResultSet. Furthermore, we are currently looking for the same kind of optimisation in the other way, insert in JDBC batch mode. (https://www.tutorialspoint.com/jdbc/jdbc-batch-processing.htm) I get in touch with our Sales Engineer and we will continu to discuss this by email. When we will have improvement, i'll update this theard.
go to post Guillaume Rongier · May 31, 2017 Hi, Have you try to type your SQL parameters : set param(i,"SqlType") = 12 //12 for SQL_VarCharI hope this will help you.
