Performance of SQL Passthru Query in a loop

Hello,

I have a need to execute a SQL Passthru query(SQL Server) inside a loop. The loop number will be hundreds per day. In the example below, this loop of 100 takes about 6 seconds. Using SQL Profiler, I can see the stored procedure itself executes in 0 milliseconds. It appears to me that all of the processing time is spent executing the objectPal method 'executeSQL'. Example code below. Do you have any ideas/tips on improving this performance?

Thanks,

Gary

method pushButton(var eventInfo Event)
var
    sqlSQL SQL
    db Database
    dynAlias DynArray[] AnyType
    tc TCursor
    cnt SmallInt
    LoadTagUnitID LongInt
endVar

    dynAlias["USER NAME"] = "USERNAME"
    dynAlias["PASSWORD"] = "PASSWORD"
    db.open (":ArrowSys:", dynAlias)

    for cnt from 1 to 100
        sqlSQL.wantInMemoryTCursor(Yes)
        sqlSQL.readFromString("execute spParaBox_LoadTagUnitInsert 195195, " + String(cnt) + ", 100;")

        executeSQL(db, sqlSQL, tc)
        LoadTagUnitID = tc."LoadTagUnitID"
        tc.close()
    endFor
endMethod

I don't think there's any way to make a significant change, other than "fastest machine you have".. you can do 1000 loops in a minute.. that seems quite reasonable

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN