Difference between Connection Oriented architecture and Disconnected architecture?
Updated on October 16, 2014 VIKRAM 2768
|The application will establish a connection with database server and it will be kept open until unless the task has been completed.||The required data will be fetched into the dataset and then the connection will be closed.|
|For each and every opertaion we need to communicate with database server, so that traffic to the database server will be increased.||The required data manipulations will be done on the tables into the dataset and the changes will be updated back to the database at once, so that traffic to the database sever can be reduced.|
|Parallel transactions will be easy.||Parallel transactions will be difficult.|
|Fetching the data will be fast.||Fetching the data will be slow.|
|No memory management is required.||Memory management is required for dataset.|
If you enjoyed this post, please like (or) share this article.