Problems filtering using *

poloba
poloba Member Posts: 15
edited 2006-10-10 in NAV/Navision Classic Client
I have a big problem.
My database is over 40GB and I have a table of 10GB. The users filter in that table and is all ok, the problem is when the user filter usin *. This filter kill the server over 5-7 minutes and nobody can work with Navision.
¿Can I do anything?

Comments

  • Kowa
    Kowa Member Posts: 926
    Create a key for the field to be filtered (this will increase the size of the table somewhat) and tell that users to select that key before filtering.
    Kai Kowalewski
  • poloba
    poloba Member Posts: 15
    The field is key.
    When the user filter without * the search is instant. If they uses an * then is the problem.
  • Kowa
    Kowa Member Posts: 926
    Are you using the native or the SQL server ?

    If the field is the first ( or only ) field in the key (it not just part of a key at 2nd,3rd etc. position) there not much else to speed it up. Optimising the table may improve it a little, but this has to be done regulary (weekly) and can take some time if the table has many keys.
    Kai Kowalewski

Categories