Topic: The server on the basis of Access
I here faced a performance concern.
Application with the partitioned basis, multiple user, on the client difficult enough logic, in a normal mode immediately with basis of the big exchange is not present, all works normally. But it was required to fasten import from Ekselja. After obtaining a short line dataful and handlings, at saving there is intensive enough data interchange with basis, any reversal to basis occupies 100-150 microseconds, as a result at a slow network single line saving occupies the order of one and a half seconds. If is by the same machine 1000 lines are saved for some seconds.
There was an idea: to place additional basis with logic of import on the same file server where is , the client application copies an import file there and far off launches import, receiving in the answer broad gulls and messages.
Somebody did such here the third level in Aktsesse, some kind of an application server?
Do not offer passage to server basis, there at the client the troubles, it does not approach it.