Will external SQL keys affect Navision?

jeby
jeby Member Posts: 2
edited 2003-09-09 in Navision Financials
I'm creating an EDI application for a customer, and am having to query Warehouse Ledger Entries to get item quantities. Due to the number of ledger entries, my SQL queries keep timing out. I've placed SQL keys on the Item No. and Zone Code fields to speed things up, but want to make sure that I'm not affecting Navision functionality/performance. Anybody know of any potential problems here? Thanks

Jonathan

Comments

  • Sbhat
    Sbhat Member Posts: 301
    Hi,

    If you are running Navision on SQL then yes, the process will create problems with indexing and will cause the system to run slow.

    Thanks
    Best regards
    Suresh
    New York.
  • eromein
    eromein Member Posts: 589
    I don't know SQL so this could sound stupid...

    Can't you use a flowfield to get this value, or is a flowfield in SQL as slow as looping all records?
    "Real programmers don't comment their code.
    If it was hard to write, it should be hard to understand."

Categories