I have a custom VB application that connects to an Oracle database (220.127.116.11). It inserts records into an interface table then disconnects from Oracle. The VB app is on about 400 PCs with about 5000 inserts into the interface table daily. My question is having this app connect and disconnect so many times all day long hurting the database? Would it be more efficient for these 400 PCs to just remain connected all day without ever logging out? Any opintions?
November 2, 2005 8:49 AM
November 22, 2005 5:10 PM