Such as title, is doing A data transmission, from one server to another server B transfer the specified table data, required data are successfully inserted into the server B, then delete the server A data, namely to ensure complete data upload,

I now is two query open at the same time, detailedly, first insert, delete again, so can meet the requirements, but the efficiency is the lowest, please save people if they have other methods can be used? I hope we will provide some methods more, thank you.

CodePudding user response:

How much data, two servers, one out and put them on another server

CodePudding user response:

Can not put the data in a property grouping, and then up multiple threads, a thread to handle a set?

CodePudding user response:

I have read that exist within first, wrote on the server...

CodePudding user response:

The bottleneck of this case is used by the database interface, see if record API provides the batch, speaking, reading and writing

CodePudding user response:

reference 1st floor ksrsoft response:

how much data, two servers, then removed to a on another server

Around one million, the amount of data

CodePudding user response:

refer to the second floor silverpot response:

can not put the data in a certain attribute group, then up multiple threads, a thread to handle a set?

I generally did the same now, but found no obvious increase, speed and

CodePudding user response:

reference liuyich123 reply: 3/f

I read within first, wrote on the server...

Yes, but a process, a speed is slow,

CodePudding user response:

Can write ah, quantities, but also quite slow, and the connection when the last write down of a parameter

CodePudding user response:

This kind of data transmission, seemingly used to have my own method of mass data processing, the original poster can go to ask to used area

CodePudding user response:

Are generally use database tools such as DTS guide,

CodePudding user response:

The

references to the tenth floor songhtao response:

are generally use database tools such as DTS guide,

Well, generally it yourself is to use of DTS and so on, but it is the requirement that can transmit data automatically, and can have certain compatibility, namely when something goes wrong to record details of the error record and to carry on the corresponding processing,

CodePudding user response:

Use stored procedures + multithreading + transaction would hurry up?

CodePudding user response:

DTS package and then with dtsrun command line call, do homework,

CodePudding user response:

Suggestion: derivative according to finally get through database management system to deal with the server itself, all the best to the database management system (such as: SQLSERVER2005, etc.) to do,
Through the program implementation threw the SQL commands directly to the database management system to deal with,
For example:
Insert into TAB_WZFFBASE
SELECT *
The FROM OpenDataSource (' Microsoft. Jet. The OLEDB. 4.0 ',
'Data Source="c: \ DB. MDB"; User ID=Admin; Password=')... Sheet2 $
The above is to. In the data table writing essentially in the MDB TAB_WZFFBASE table, this command directly thrown to used to do,
For in the program schedule shows, you can each table to guide, several records in or block,