niche Posted October 18, 2010 Share Posted October 18, 2010 say 300 users just produced input that requires access to the same table and the same columns at more or less the same time.Doesn't the server provide access on a first come first served basis resolving simultaneous request in some equatable fashion?Also, is there a metric that identifies how many simultaneous requests can be handled before it resets, freezes, to just becomes too slow? If so, what's it called? Link to comment Share on other sites More sharing options...
justsomeguy Posted October 18, 2010 Share Posted October 18, 2010 A good database management system will ensure ACID transactions:http://en.wikipedia.org/wiki/ACID Also, is there a metric that identifies how many simultaneous requests can be handledNot really, different transactions can take different amounts of time so there's no one metric. There are a lot of tools to help analyze how the database gets used though. SQL Server, for example, has a profiler that you can run to analyze all of the queries that come in on a database and suggest things like changes to indexes or data types to make things faster. Link to comment Share on other sites More sharing options...
niche Posted October 18, 2010 Author Share Posted October 18, 2010 justsomeguy, thanks for your time and help.Niche Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.