Re: convincing a client to go with dotNet instead of Access project
- From: "Flip" <[remove_me]phenry_w@xxxxxxxxxxx>
- Date: Thu, 28 Apr 2005 17:25:05 -0400
> Do you have reference for the performance threshold of 6 concurrent
> connections that I can point to?
I tried doing a quick search, but wasn't able to find anything. :<
The last time I had this problem, I quickly whipped up an Access db, and
accessed it using Access forms, and a VB form, and started loading up the
number of concurrent users. And although Access was willing to accept the
other connections (7+), the performance started to decrease, almost
exponentially. Maybe it was the size of the db, or the type of data I had
in there, but it was quickly evident it wasn't going to be work for our
situation.
To help show your boss just how good .NET stuff is, maybe this is a
worthwhile scenario to test out? Create an Access DB, an Access form, a C#
app as well as the same DB in SQL Server. Then have the forms (Access and
C#) bang against each and see out of the four where the performance
bottlenecks are. Try to use threads in the C# apps to truely get the
concurrency thing going, just a suggestion.
> That would be good documentation to have...
I know! :< But I'm sorry, I wasn't able to find any. I think that was more
tribal knowledge at that time. Sorry about that, I'm doing java/jdbc dev
during the day now, just getting back into MS dev (C#). The best I could
find was articles talking about a limit of 255 concurrent users. However,
they also talked about the bigger the db, the worse your performance as the
number of concurrent users increased. So that 255 max is still a
theoretical number still.
I would suggest whipping something up to show your boss the .NET
flexibility, ease of development, ability to do proof of concept, as well as
taking owership and R&D initiative. Good luck!
.
- Follow-Ups:
- Re: convincing a client to go with dotNet instead of Access project
- From: Cor Ligthert
- Re: convincing a client to go with dotNet instead of Access project
- References:
- Prev by Date: RE: How can I store a PDF file in a SQL database?
- Next by Date: Xml Deserialization with Visual C++ .NET
- Previous by thread: Re: convincing a client to go with dotNet instead of Access project
- Next by thread: Re: convincing a client to go with dotNet instead of Access project
- Index(es):
Relevant Pages
|
