B4J Question Which method of connecting to the database is optimal?

[behnam_tr]

hi.
Which method of connecting to the database is optimal?
My focus is on memory usage.

1-Persistent connection
Connects to the database from the start of the program and does not close until the end of the program.

'mainform
public SQL1 as SQL

sub start
    SQL1.InitializeSQLite("", DBFullPath , False)
end sub

sub mainform_closed
  SQL1.close
end sub
--------------------------------------------
'use in other classes and modules
   main.SQL1.ExecNonQuery(......)

2- Intermittent connection
Connect when needed and disconnect immediately after operation

'creat class DBManageClass
private SQL1 as SQL

sub Initialize
   SQL1.InitializeSQLite("", DBFullPath , False)
end sub

sub ExQuery()
 ...............
end sub

sub disconnect
   SQL1.close
end sub
--------------------------------------------

'use in other classes and modules
   dim c1 as DBManageClass
   c1.Initialize
   c1.ExQuery(......)
   c1.disconnect
  
   dim c2 as DBManageClass
   c2.Initialize
   c2.ExQuery(......)
   c2.disconnect

 

[tchart]

#2 but with a connection pool. When you use a pool you open and close the connection immediately and it goes back into the pool. This means there is no delay when reopening a connection.

#1 is fine but limits you to a single connection, this is okay for some apps but not where there are multiple users.