Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

deadlock in MS SQL 2000 but not in Postgres

 
raj varma
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am facing deadlock in MS SQL 2000 sp3, but same code does not face any deadlock in postgres 7.3 database. How do i resolve the problem ?
Even same case happpnes for time taken by postgreas to retrive @15000 records is @4-5 seconds and same no. of records is fetched by ms sql 2000 is @8-10 minutes.
Please Help me.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I don't know how Postgres compares with MSSQL Server, but I do know that MSSQL Server has a lower deadlock threshold than DB2 and Oracle i.e. it takes fewer concurrent operations in MSSQL Server to cause deadlock than in the other two. I'd check the Database documentation and see if this is the issue. I'd check your driver documentation too - it might be something to do with how/when it actually runs queries.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic