Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / SalesInvoiceLineV3Enti...
Finance forum
Suggested answer

SalesInvoiceLineV3Entity latency

(1) ShareShare
ReportReport
Posted on by KP-08101030-0 31
Hello Team,
 
Currently retrieving data from the entity SalesInvoiceLineV3Entity, it takes 20 seconds to execute below query
 
select TOP 1 * from SalesInvoiceLineV3Entity where dataareaid = 'AAA'
 
Is this normal. I need to retrieve historical data from 2019 to 2024.
 
Anyone faced the same problem and any workaround please.
 
Thank you
Categories:
Finance
  • KP-08101030-0 Profile Picture
    KP-08101030-0 31 on at
    SalesInvoiceLineV3Entity latency
    i am executing on the database directly. Should have been fast. but very slow
  • Suggested answer
    Waed Ayyad Profile Picture
    Waed Ayyad 5,739 Super User 2024 Season 2 on at
    SalesInvoiceLineV3Entity latency
    Hi,
     
    Are you using Data management? Did you try to use recurring job in DMF?
     
    Thanks
    Waed Ayyad
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Replay: Dynamics 365 Community Call ERP Edition | October 9, 2024

Another great gathering of our Community!

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

More Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,665 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,971 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,150

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans