hi all,

I would like to know about the common ways of retriving data from database. I have developed an application using asp.net(vb.net), sql server 2000. Somewhere I have used stored procedures but in most the the pages I have written insert, update and select queries in codebehind page and used sql command object to execute the queries.

I have used mixture of connected and disconnected architecture. As this is my first asp.net project I don't know whether such conding style have bad impact on performance of application.

as this is internal application and we are hosting it on our own web server the security issue may not arise.

Will writing queries in codebehide page degrade the performance of application. The database server and web server are on the same machine.

Do I have to convert all the queries into stored procedures? Is is a very bad practise write the queries in codebehind pages??

Kindly share your experiences. So that I can improve my knowledge regarding the performance of application.

Hi Swati

Definately using stored procedure would increase the application performance, firstly bcoz they are pre-complied, secondly queries where results are obtained after executing 2-3 queries can be done in a single stored procedure.

But if ur application is not that big, and hosted internally, then there should not be signification difference in performance.



Regards
Mike

hi,

Thanks for your reply. I was afraid whether i need to convert all the front end quesries to back end. but the application is not too heavy. I think internet connection speed affects the loading of the pages.

Yes Swati

You are correct, since your application is an internal application and doesn't have much load balancing, you can continue with front end queries, no need to convert your queries to Stored Procedures.

Any other doubts, do let us know.

Regards
Mike