General: C/Side Database or SQL? Experiences?

Wayne

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.

bo

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

We have 7Gig, Attain 3.6, and the user have sometimes blockages from other users.

bo

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

If you use the manufacturing module, you have some errors delivered in the standard versions.

with small corrections your can optimize your system.

regards tirta