Hello I'm new to this forum, but I've been programming for sometime. I had a question about performance on a web application. One of my projects is a web application, written in ASP.NET (VB.NET) using SQL Server 2005 on the back end. The application has 4 drop down list, and a 4 data grids all populated by the back end with complicated queries on a few of the data grids. I use the datareader object to get data back from the database.

The application allows the user to add, update, delete and read data from the database; which is standard. The application is structured so that all database connection and commands are in one set of files and the presentation of the application is in another. I compile the entire site into a dll with the .aspx pages separate. I have used the Cache object to cache some of the data in the server memory, to try to improve performance. But I'm stilling getting performance issues with the user entering records.

Could you please provide some insight on what else I can do to improve performance? I've thought about XML and a local application, but I would rather not go do down that route if possible. I think the issue is with the round trip to the database, but I don't know the best way to get around that.

Please let me know.

Thanks,

dygytalnomad

do_tuong at yahoo dot com