General information
Category:
COM/DCOM and OLE Automation
>Hi, Everybody!
>
>I'm just starting to study and do n-tier development, and I'm with a couple of doubts, that I'm solving on each thread here on UT. :-)
>
>Please, for every issue (performance, beauty, etc...), what would do the best approach to pass data through objects and layers:
>
>* Use ADO everywhere
>
>or
>
>* Use SQL-PassThrough to access data, and after work with this data, create a "fabricated" RecordSet, and populate it, and later pass it ahead??
What is your target database?
From a performance point of view ADO will do better than SPT, especially if you can use an OLEDB provider. For an ODBC data source it can go either way.
But like Craig said, for passing data through layers in an n-tier design SPT is not a choice.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only