SQLDataAdapater Class

[Shakthi]

Hi Friends,

What will be the effects when more number of
SQLDataAdapters used in an application. Do they the slow
down the application speed?

If any other effects pls let me know.

Regards,

Shakthi

 

[Marina]

They themselves will not do anything, they are just like any other object.
They will take up some space in memory.

 

[Shakthi]

Hi Friends,

Thanx for your information.

Really my application is damn slow. As per my application
archietecture SQL Transactions were put inside the
Business Layer. Presentation Layer just use the object
references and play round with it precisely speaking =
the Sqldataadapter i declared as public in fragment of
Business layer and invoked across the client application.
Whether its good practise r bad?

Pls show some lights to make it bright. If u have any
better tech. Pls suggest me.

Regards,

R.Shakthi