1

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.

2

Re: The server on the basis of Access

Now here I try to understand, how it is better to launch "application server" by the remote machine and as it is better to communicate with it. While to a head of anything the best does not come, than start under the schedule by the remote machine of the command file which checks on presence of a new file of import and starts handling application. Application, in turn, writes broad gulls and requests to the user to basis, and the client application on the timer analyzes these broad gulls/inquiries and transfers commands back the same ugly method.
Whether two can  applications,  by different machines, communicate among themselves directly, passing the intermediate tables/files and timers? I suspect that is not present,  on  the CATFISH

3

Re: The server on the basis of Access

Can make the table locally? On the client to it to import a file, and further this table already to copy in the table in the general basis (to add or update).

4

Re: The server on the basis of Access

The server does not work Access normally as a file.
It was considered tens times.

5

Re: The server on the basis of Access

6

Re: The server on the basis of Access

Here to you other idea. At first import in a local DB with the interface is fulfilled, and then given by one request are copied in a fighting DB. As it is a question of copying of the whole table which in basis of assignment is not present, process should be fast.

7

Re: The server on the basis of Access

MrShin if there is  a procedure with entering of set of records in Recordset, opened on the table of a network DB to accelerate process it is possible application of transaction or usage ADODB.Recordset with batch update (UpdateBath).
And that you want to stir up - does not fly up ().

8

Re: The server on the basis of Access

alecko wrote:

can make the table locally?

Yes, such variant is considered, but there tens tables on which the data and the environment multiple user are spaced apart,  it will settle all, also, as well as with copying from local basis as offered Akina, but it is possible. The basis not such small, copying on the local machine  to eat a scoring.

(Kiev) wrote:

process it is possible application of transaction or usage ADODB.Recordset with batch update (UpdateBath)

Transactions are already used, it really gives acceleration almost in 2 times. How think, it makes sense batch update ? It seems to me that the difference will be small.

(Kiev) wrote:

that you want to stir up - does not fly up

Here at me too such suspicions. Simply batch processing on the server at us is used for a long time, back only the end result is transferred, and here it would be desirable  to add. But all is sick it clumsily it turns out.
if the server basis could be used...

9

Re: The server on the basis of Access

Whether

MrShin wrote:

two Can  applications,  by different machines, communicate among themselves directly, passing the intermediate tables/files and timers? I suspect that is not present,  on  the CATFISH

Taki can, simply  on the modern OS of access right on DCOM adjust. Syntactically all begins easier  turnips, the second parameter CreateObject () see. But nuances too will be. For example, if it wants an asynchronous method call of a server object. Then also timers can appear as a message queue implementer.

10

Re: The server on the basis of Access

MrShin wrote:

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.

Did about 6 years ago similar megacrutch, disgustingly. In excele owing to singularities was the order of 14000 lines, from 36-38 fields. All  at import. You can implement certainly, but it is a deadlock branch of evolution. Plus sometimes a file server why that  also there were saved backup copies of files. .
Can all the same try to drag on mysql or ms sql. The jacket can same be left. If your client works in  it after all it is absolute as well continues to work there.

11

Re: The server on the basis of Access

MrShin;
I do not see hindrances...
I did almost similar for one of broker offices, there it was necessary to trace change of courses in real time... The Task approximately such - whence that (not important) arrives the notification on a course change for a position (positions) and it is necessary that all on monitors had an actual state automatically...
- The basis lies on the server
- At users necessary from basis be constant on the screen owe to the actual.
The decision about the such:
1. The client part on the timer (the user adjusts, from steam of seconds about one minutes) checks value of the counter
Changes in a DB if it changed, updates screen contents.
2. On the server the background job which on the timer (too it is adjusted) checks contents of a certain folder hangs. If in it (it is not important as) there is a notification (a file of a certain format) on a course change of that or, there is a change of the given course in , magnification of the counter of changes and relocation of the processed file in a folder to archive of changes of courses...
All remarkably works! Also it is reduced to that it is necessary to throw simply in a certain folder a file of changes (at you it is import).
The feeble place in your case - curve files  (I had a rigid format), here is necessary (if what not so)
Import of a file not to do generally, and a curve file  together with its broad gull to throw not in archive, and in a folder spoilage...

12

Re: The server on the basis of Access

MrShin;
Throughout: .

13

Re: The server on the basis of Access

vmag wrote:

I do not see hindrances...
I did almost similar for one of broker offices

Yes, it is quite efficient, I dislike timers only owing to actual  Aktsessa. If speed in the current version does not arrange, approximately and we make.

sdfJh24on wrote:

Throughout:

Interesting... But, I am afraid, it also does not approach for the same reason, as the server DB - department-customer at all does not want to depend on own IT, a maximum a local network with  smile However, for very large companies, type of this client such paradoxical requirements not a rarity.