Multiple queries being requested on for same table
-
Hii Everybody, I have one doubt or fundamental unclarity about database. I would like to know what happens or how does any RDMS database responds to multiple queries being requested from several clients on a table simultaneously ? Example : There is a table called customer which has all the required fields of a customer namely age, name. dob etc... Now there are several clients around the world trying to query this table with several requests. Some clients are trying to insert customer details, some are trying to delete customer details and others are trying to read those customer details simultaneously on customer table. The clients trying to insert, delete are admins while the clients trying to read are staffs. In this case how would the table handle those multiple queries at the same time.Would it crash, behave differently etc.. ?
Aspiring Techie, Vishnu Nath
-
Hii Everybody, I have one doubt or fundamental unclarity about database. I would like to know what happens or how does any RDMS database responds to multiple queries being requested from several clients on a table simultaneously ? Example : There is a table called customer which has all the required fields of a customer namely age, name. dob etc... Now there are several clients around the world trying to query this table with several requests. Some clients are trying to insert customer details, some are trying to delete customer details and others are trying to read those customer details simultaneously on customer table. The clients trying to insert, delete are admins while the clients trying to read are staffs. In this case how would the table handle those multiple queries at the same time.Would it crash, behave differently etc.. ?
Aspiring Techie, Vishnu Nath
This is way too complicated of an issue to address through a forum discussion. You have to have some faith in the database engine that it can handle multiple requests without crashing. :) Seriously, this is a very advanced topic that could take months to understand. Let me suggest a very interesting book, http://www.amazon.com/Inside-Microsoft-SQL-Server-2005/dp/0735621055/ref=sr_1_1?ie=UTF8&s=books&qid=1253200333&sr=8-1[^] This book can give you some insight into how the MS-SQL server works.
-
Hii Everybody, I have one doubt or fundamental unclarity about database. I would like to know what happens or how does any RDMS database responds to multiple queries being requested from several clients on a table simultaneously ? Example : There is a table called customer which has all the required fields of a customer namely age, name. dob etc... Now there are several clients around the world trying to query this table with several requests. Some clients are trying to insert customer details, some are trying to delete customer details and others are trying to read those customer details simultaneously on customer table. The clients trying to insert, delete are admins while the clients trying to read are staffs. In this case how would the table handle those multiple queries at the same time.Would it crash, behave differently etc.. ?
Aspiring Techie, Vishnu Nath
This is, as the previous post said, its a complex subject, but you need to accept the fact that this is what databases do, and do very well, and they work - as long as you understand about isolation levels and transactions. At my current client there are upwards of a thousand users htting teh database with inserts, updates, delets and plain old reads all day long without any real problems, and this is commonplace.
Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP
-
This is, as the previous post said, its a complex subject, but you need to accept the fact that this is what databases do, and do very well, and they work - as long as you understand about isolation levels and transactions. At my current client there are upwards of a thousand users htting teh database with inserts, updates, delets and plain old reads all day long without any real problems, and this is commonplace.
Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP
Thanks for giving out your suggestion. Well databases must be having robust engine to handle the queries. But its fuctioning and understanding is important while building a database driven web application. Also was thinking how facebook, orkut would be using their databases to manage their user queries around the world.
Aspiring Techie, Vishnu Nath
-
Thanks for giving out your suggestion. Well databases must be having robust engine to handle the queries. But its fuctioning and understanding is important while building a database driven web application. Also was thinking how facebook, orkut would be using their databases to manage their user queries around the world.
Aspiring Techie, Vishnu Nath
Vishnu Nath wrote:
But its fuctioning and understanding is important while building a database driven web application.
So you need to do more research than you will get from asking in a forum. Buy a few books on your chosen database (SQL Server, Oracle etc) and investigate further.
Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP