| Author |
Topic |
|
workaccount
Starting Member
4 Posts |
 Posted - 2007-09-26 : 09:16:44
|
| We are using Navision with SQL server 2003.What kind of methods is there out there to reduce hwo often this happens? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-26 : 09:20:52
|
By contacting the producer of NAVision and tell them to write better code  You don't tell us if it is the "out of the box" modules that faults, or some hands-on modifications that faults.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
workaccount
Starting Member
4 Posts |
Posted - 2007-09-26 : 09:56:36
|
| Yes but we use another company that has designed it for us the way we need it.Surely this is SQL optimazation though? Maybe your just Linux/UNIX/FreeBSD zealots? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-26 : 10:45:34
|
I think the company managing your customizations should be asked.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-09-26 : 11:15:39
|
quote:
Originally posted by workaccount
Maybe your just Linux/UNIX/FreeBSD zealots?
you won't find many of those on this forum as SQL Server does not run on any OS other than windows...
elsasoft.org |
|
|
|
workaccount
Starting Member
4 Posts |
Posted - 2007-09-26 : 11:47:00
|
| What about MySQL, PostgreSQL |
|
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2007-09-26 : 12:42:28
|
| This forum deals with Microsoft SQL SERVER. Not any other flavor.[Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-26 : 12:45:51
|
Almost same locking algorithms goes for all RDBMS systems.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-26 : 22:19:31
|
| As said, blocking usually caused by bad coding that holds locks too long. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-27 : 02:51:21
|
Mostly I see this at clients site where they overuse the IN, or NOT IN, keyword.When I change it to LEFT JOIN, INNER JOIN, EXIST, NOT EXIST, the problem goes away.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
Users get blocked by other users alot