Post reply

Querying the DB in Enterprise Manager Creates Locks

  • January 22, 2008 at 12:06 pm

    #91637

    Hi we are having a problem on our live server.... whenever we run a query on one of our major tables in Enterprise Manager, it creates locks in which slows down/cripples the application. Any thoughts why?

  • January 22, 2008 at 12:52 pm

    #770621

    John Kandrovy (1/22/2008)

    Hi we are having a problem on our live server.... whenever we run a query on one of our major tables in Enterprise Manager, it creates locks in which slows down/cripples the application. Any thoughts why?

    Check if you retrieve all the data. As long not all the data of your query is retrieved, shared locks will be held.

    Same thing with Access, it retrieves 30 records (to appear fast and sleek) and waits for the user to scroll down in order to fetch all the data.

    *edited

    added of your query for clarity

  • January 22, 2008 at 1:16 pm

    #770634

    Thanks... we'll have to check that out... because we were querying a table that has over 100k rows and the result set can be a few hundred.

  • January 22, 2008 at 1:28 pm

    #770639

    You may change your transaction isolation level or add NO_LOCK clause in your queries.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply