General: C/Side Database or SQL? Experiences?

Wayne
Wayne Member Posts: 20
edited 2003-08-08 in Navision Attain
Is there a general recommendation.
Is there a maximum number of user for C/side?
We have more than 200.000 AVP Artikelverfolgungsposten
and runing Attain for 1/2 an year.

Are there positive experiences in changing C/Side to SQL.

Comments

  • bo
    bo Member Posts: 3
    What size is the database now? Which Attain version do you use?

    Basically, migrating form native database to SQL can range anywhere between a simple task and a complex project, depending on how much customer-specific development you did.

    Can you tell a little more?
  • Wayne
    Wayne Member Posts: 20
    We have 7Gig, Attain 3.6, and the user have sometimes blockages from other users.
  • bo
    bo Member Posts: 3
    Well, 7 Gig shouldn't be a problem. In fact, performance of smaller DBs is much better with Navision Database instead of SQL.

    To solve your locking problem, I'd take a very close look at customer-specific code. Maybe the locking isn't done properly or the code runs too slow, perhaps due to missing key usage etc., resulting in longer locking.
  • Tirta
    Tirta Member Posts: 53
    If you use the manufacturing module, you have some errors delivered in the standard versions.

    with small corrections your can optimize your system. :wink:

    regards tirta

Categories