Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Navision (or any SQL application) - System resources & Locked tables

  • 30-07-2007 03:50PM
    #1
    workaccount
    Closed Accounts Posts: 2,460 ✭✭✭


    Is there any workaround for the pre-action table getting locked?

    Is there not some way the system can make a duplicate and compare the data before merging them again or something so multiple people can work on it?

    Also, how can I go about implementing time slicing of the CPU so users have a more consistent interface and don't hog resources for everyone else by creating reports and stuff?


    Cheers.


Comments

  • #2
    chugelin
    Closed Accounts Posts: 1 ✭chugelin


    Hello,
    I was wondering if Microsoft or any partners had an answer for you. Simply put, how can Navision be an enterprise solution when that table can be locked up for hours on foreign exchange updates. I can't even do any user setups, etc...

    Makes no sense.

    Thanks


  • #3
    workaccount
    Closed Accounts Posts: 2,460 ✭✭✭workaccount


    If your machine is locked for several hours you must be using a very slow computer.

    Large database jobs need very powerful machines.

    I'm not sure exactly what this foreign exchange job is your running but I know some processes on our system can take a long time.....and that's on a system with four xeons and 16G of ram.


Advertisement