connect/disconnect?

[Silver CHEN]

Dear Sir:

  I have a simple question about the client program design.

  If I have an login authetication database for some topic, and
  some relative C programs included.

  My problem is, should I connect-query-free-disconnect for each
  authetication process, or just to check the connection first, and
  re-connect only if the connection is lost?

  I don't understand the inside story, but I do know that there is
  something called 'presistent connection' for frequent database
  activities.

  If the latter method is used, then where is the 'connection' when
  one process exit? and how the new process use/know the 'presistent'
  connection handle?

  Thanks for your help, if I made something wrong, please tell me.

-- 
+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+
|    Shan-Ta CHEN                    E-Mail : sansil@stripped   |
|    Silver CHEN                     Tel(O) : [phone]   |
|    陳善達                          Tel(H) : [phone]       |
+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+