SQlite Shutdown

[pcsimke]

When is good time to do _SQLite_Shutdown() , in my program there is lot of buttons that need to query _SQLite so i made little function for that

something like this below , my question is is it good practice to open and close database at every query , or open database at program start and close it when you exit program

Func _bazaread ($upit)
    
    Local $sSQliteDll = _SQLite_Startup(@ScriptDir & "\include\sqlite3_x64_300801000.dll", False, True)
    If @error Then
        MsgBox($MB_SYSTEMMODAL, "SQLite Error", "SQLite3.dll Can't be Loaded!" & @CRLF & @CRLF & _
                        "Not FOUND in @ScriptDir, @WorkingDir," & @CRLF & @TAB & "@LocalAppDataDir\AutoIt v3\SQLite," & @CRLF & @TAB & "@SystemDir or @WindowsDir")
        Exit -1
    EndIf
    $dbn = _SQLite_Open("include\statisika.db3")
    
    _SQLite_Query(-1, "SELECT "&$upit, $hQuery) ; Upit iz baze stavljamu u array
    While _SQLite_FetchData($hQuery, $aRow) = $SQLITE_OK
    $podatci = $aRow[0]
    WEnd
    
    _SQLite_Shutdown()
    Return $podatci
    EndFunc

 

[jchd]

Code like this:

At program start:
_SQLite_Startup
_SQLite_Open

proceed with the main code

before exit:
_SQLite_Close
_SQlite_ShutDown

Prefer _SQLite_GetTable[2d] to your use of _SQLite_Query and _SQLite_FetchData