Re: Which type of connection to be used in multi-ser environment?
- From: "William \(Bill\) Vaughn" <billvaRemoveThis@xxxxxxxxxx>
- Date: Tue, 19 Jul 2005 10:11:15 -0700
Scaling a JET database with an Access application to 5 users is entirely
possible--assuming the application has been designed from the beginning to
support multiple users.
JET/Access runs on each client system and simply shares a common file. All
file IO is transmitted over the network so if your design pulls down large
rowsets (Recordsets) you're in for a disappointment. This architecture is a
throw-back to the 8-bit CP/M Dbase days. Leaving the connection open is fine
for this type of application, but the connection pool can help keep the
number of connections each application makes by opening the connection just
in time and closing it as soon as you're through with it. I expect
connection overhead will be the least of your worries.
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Swap" <Swap@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0FEF4ED6-6285-49A6-BE8F-52BADC482683@xxxxxxxxxxxxxxxx
> Hi all,
> I have a desktop application which has MS-Access as the DataBase.
> In our current application we were maintaining persistent connection to
> the DB.
> Now, we are planning to upgrade the application to multi-user
> environment. I want some suggestions if I can maintain persistent
> connection for each user. I want know if it will effect the performance
> or any network problems or any other problems. The application can have
> approximately 5 users. I want to know which type of connection is best.
> Connecting to DB when itz required or maintaining persistent
> connection.
> Any suggestions are welcome.
> Thanks,
> Swapna.
.
- References:
- Prev by Date: Microsoft OLE DB Provider For Exchange Connection string Issue
- Next by Date: Re: runtime error 3075..
- Previous by thread: Which type of connection to be used in multi-ser environment?
- Next by thread: Microsoft OLE DB Provider For Exchange Connection string Issue
- Index(es):
Relevant Pages
|
|
