C/SIDE Database syncronisation

eaf-gmbh

Hello,

Is there a possibility to sycronize the aktual C/SIDE Database 1:1 with an other database (technicaly 3.7 Navision)?

Background:

We have up to five Navision Clients to import/export Data for our Webapplication. This takes a lot of prozessing time and the performance for normal Navision work is very slow, and in the worst case the users are blogged for a long time.

Can we realise this with the C/Side Database or have we to change SQL?
If SQL ist the only possibility, I even would be glad for some tips in this post.

Thanks in advance,
Thorsten Muhlak

kine

The SQL may be solution. But "may be"! It depends on what and how you are processing, what are doing others etc. You need to check where is the bottleneck, if it is hardware and you have fast processor and more than 1GB RAM and many HDD pairs with the Database, the SQL can helps you, because it support more processors, more memory. Of course, SQL has higher requirements for optimalization of keys and code.

kriki

But probably it will be that those sessions lock some tables for a too long time because their transactions are too big. In this case try to make the transactions smaller.
Or maybe the sessions (or better the objects they use) use some wrong indexes to find records.

eaf-gmbh

Hello,

There is somthing I forgot.
The reason for the sycronised DB: All the Clients doing the export should use the sycronised DB, to stop slowing down the database for the users. The Hardware is OK and Diskspace is optimized for fast acces.