Re: How to improve database controls in ASP

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks

"JeffP@Work" <jpgmt_at_sbcglobal_dot_net> wrote in message
news:uqJ6fo01GHA.2196@xxxxxxxxxxxxxxxxxxxxxxx
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....

"James" <jpo_22@xxxxxxxxx> wrote in message
news:%23Wl2HKw1GHA.1256@xxxxxxxxxxxxxxxxxxxxxxx
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.





.

Relevant Pages

  • Re: In FrontPage 2003 what is a thicket?
    ... | and database connections. ... | as good), the error, "Database Results Wizard Error ... | the file was part of a thicket and could not be changed. ...
    (microsoft.public.frontpage.extensions.windowsnt)
  • Re: aggregation class ideas?
    ... I also have database abstraction class that is ... database connections in your application, ... situation, the active record, table gateway, or data mapper patterns ... mapper pattern even in simple situations, ...
    (comp.lang.php)
  • RE: Memory Leak in C# Windows Service
    ... With your database connections and datareaders you want to make sure ... > jobs and starting to "sleep". ... Actually the service is working fine except memory leak, ...
    (microsoft.public.dotnet.general)
  • In FrontPage 2003 what is a thicket?
    ... I was trouble shooting a Web for someone who was running active server pages ... and database connections. ... the file was part of a thicket and could not be changed. ...
    (microsoft.public.frontpage.extensions.windowsnt)
  • Re: How to improve database controls in ASP
    ... I'm not sure why this is ocurring, but here are some common issues... ... Be sure that post SQL query, your database connections close when they ...
    (microsoft.public.dotnet.framework.aspnet)