SQL performance Item sorting Search Description

erben
erben Member Posts: 2
edited 2013-11-18 in NAV/Navision Classic Client
Hi all,

One of my customers converted from Native to SQL a few weeks ago. Overall performance is OK.
There is one situation however that shows unacceptable performance.

If I browse through an Item Card (even a newly created one with only "No." on it) while the sorting is set to "Search Description" the performance is poor. Using the Client Monitor we can see that sometimes a FINDNEXT can take up to a minute.
Using other secundary keys is no problem at all, just the Search Description.
NAV Version = 2009sp1 (objects 3.70), SQL = 2008 R2

Any ideas?

Thanks.

Comments

  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    Is the SQL Index for Search Description enabled?
    Marije Brummel | Freelance Business Central Specialist
  • Kishorm
    Kishorm Member Posts: 921
    Check that MaintainSQLIndex property is set to Yes and that SQLIndex property is blank.
  • kriki
    kriki Member, Moderator Posts: 9,121
    And that you have done maintenance on your indexes (like rebuild index or at least updated statistics on them)
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories