dpms
asked on
Multi-user overview
What is involved in putting an app. on a LAN for multiple users. Just a summary will do.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Is there a big difference? Well, yes and no... it's never easy right!
Most databases, these days, are multi-user anyway. Some more then others. Like MS Access is a multi-user database, but not really an RDBMS in that it's not a database engine on the network responding to requests but a flat file system.
The biggest issue is making sure that the database design and application design provide for maximum concurrency. You don't want to have to update (and therefore lock / block) hundreds of rows at a time which will prevent others from updating concurrently.
Any more specific questions?
David
Most databases, these days, are multi-user anyway. Some more then others. Like MS Access is a multi-user database, but not really an RDBMS in that it's not a database engine on the network responding to requests but a flat file system.
The biggest issue is making sure that the database design and application design provide for maximum concurrency. You don't want to have to update (and therefore lock / block) hundreds of rows at a time which will prevent others from updating concurrently.
Any more specific questions?
David
ASKER
Thanks David!!!!
ASKER