I found something very strange while I was trying to Update few thousand records through loop.
While using table.UpdateRecord in XOJO, updating vary from 20 - 300 ms ( table has approx. 90.000 records )
Using mDatabase.SQLExecute with Update query for single record, takes 1 - 8 ms in same table.
Bellow is part of code which I'm using in XOJO,
dim startAPI as integer = Microseconds / 1000
//ADK UPDATE
tabelaAsset.RecID = idfound
tabelaAsset.BooleanField("found").Value = True
tabelaAsset.BooleanField("enbl").Value = True
tabelaAsset.UpdateRecord
dim krajAPI as Integer = Microseconds / 1000
System.DebugLog("- UPDATE API : " + Str(krajAPI - startAPI) + " ms.") // getting 20 - 300 ms
query = "UPDATE asset SET found = 'True', enbl = 'True' WHERE RecID = '" + Str(idfound) + "'"
dim sqlStartMS as Integer = Microseconds / 1000
call App.mDatabase.SqlExecute(query)
dim sqlKrajMS as Integer = Microseconds / 1000
System.DebugLog("- UPDATE SQL : " + Str(sqlKrajMS - sqlStartMS) + " ms.") // getting 1 - 8 ms
Can anyone help me understand this? I thought using VTable class should be faster than using SQL.