Extension Performance Issue

ashbhardwaj26
ashbhardwaj26 Member Posts: 3
in NAV Three Tier
Hi guys
We are using Business Central On Premise. The fields that used to be on the item table are now spread across 8 different extensions using TableExtensions. We're hitting a weird performance issue when a user open up an item Card Page or List Page i took 8 seconds for the item list to appear. there is no flow fields
In SQL Trace its just showing Joins for all tables, we also did SQL Indexing.
Has anybody seen anything similar?

Answers

  • SanderDk
    SanderDk Member Posts: 507
    Yes I have experienced this, we did a Go Live with 20+ Extension, It could not preform as expected, the problem is that NAV/BC are fetching the data with a SQL join statement, so for each extension you have on ex. the item table, BC do a join we the companion table. It does not take that long to do, but when you do this 1000 (x 8 extension) times a day, it slows the system way down.
    Our solution was to combine all table extension (if possible) into one extension, that helped the preforms a lot.
    We were told that Microsoft are trying to rethink the way the data is fetch, but so far I haven't heard that anything has been changed (jet).
    For help, do not use PM, use forum instead, perhaps other people have the same question, or better answers.
  • ashbhardwaj26
    ashbhardwaj26 Member Posts: 3
    Very Strange thing we found that there is 3-4 junk items with may be special character. so we created a view with Description<> '' & save it & then we try to open it opens very fast as normal.

Categories