How to improve database controls in ASP

  • Thread starter Thread starter James
  • Start date Start date
J

James

Hello all
I have not experience in this kind of issues...
My problem is that I create a little application in VB that uses a DataBase
(SQL-Server) and each time that I add a dataset or a SqlDataSource the
application becomes slower...
I don't know how can I optimize this website.
Please, could you help me with some steeps to optimeze this connection with
a DataBase?

Thanks a lot.
 
I'm not sure why this is ocurring, but here are some common issues...

1. Be sure that post SQL query, your database connections close when they
are no longer needed.
2. For SQL queries that require data retrieval, as only show me the data,
add after each table selection with(nolock)
e.g. Select a.mycol1, a.mycol2 from myTable a with(nolock)
3. Look at your server via the EnterpriseMgr, EM, and check that you don't
have any blocks or latent locks as a hint for #1 above.

HTH

JeffP....
 
Thanks

JeffP@Work said:
I'm not sure why this is ocurring, but here are some common issues...

1. Be sure that post SQL query, your database connections close when they
are no longer needed.
2. For SQL queries that require data retrieval, as only show me the data,
add after each table selection with(nolock)
e.g. Select a.mycol1, a.mycol2 from myTable a with(nolock)
3. Look at your server via the EnterpriseMgr, EM, and check that you don't
have any blocks or latent locks as a hint for #1 above.

HTH

JeffP....
Click to expand...
 
Back
Top