none
ADODB : recordSet.FILTER VS Connection.EXECUTE - The fastest solution ? RRS feed

  • Question

  • Hi,

    I have to use in a VBA loop of around 1000 items

    oRecordset.Filter (sCrit)

    or

     sSql = "SELECT DISTINCT * FROM ...." : Set oRSet = oCnx.Execute(sSql)

    After reading this  BenchMark, I would like developers experience feedback about the best solution.

    Last addition, 

    • MS office version is 365
    • Excel file is located on a network drive
    • Access database is on different network server of the Excel file

    Thanks by advance



    • Edited by technet65 Tuesday, January 22, 2019 9:41 AM
    Tuesday, January 22, 2019 9:25 AM