How do we measure the 'high resource consuming' part?
As a follow up, I have another question-
If pooling is enabled for a web application that is in a web farm? What is the size of the pool?
Are 4 pools created if there are 4 servers in the farm? Is a separate connection pool maintained for every distinct process, app domain and connection string?
Is there a comprehensive article that can explain the connection pooling in ADO.NET. I have already read the one on codeproject, 4guysfromrolla, google, etc., but could not find answers to my questions. I am looking for something more comprehensive.
How is Connection pooling handled in EF4.1?
Answer to original question posed in the title...
A RDBMS is nothing more than a remote interface to the consuming application, regardless of its purpose (to store data), and the smoke and mirrors (data access frameworks like O/RM) hide the lack of locality. In reality, an object oriented system with RDBMS integration is a similar to an object oriented system with web service integration: explicit remote boundaries exist and cannot be discounted. The perceived, demonized impedance mismatches are a symptom of the misconception of distributed systems. An invisible and often abused line in the sand exists (remote interface), and when crossed, incurs a significant penalty in terms of CPU and I/O cost.