more update 2 progress

finished minimizing connections to the database.