Do a debug software, BORLAND c + + BUILDER development environment, database SQL SERVER2008, PC port accept real-time data, and the INSERT statement to INSERT a detailed database table, the software runs too card, speed too slow, how to improve efficiency?? thank you

CodePudding user response:

To accept the data into the buffer, interval time, written to disk file

Program exit or open, the data file data into database,

CodePudding user response:

Write data of the partially blocked, if BuKa that is caused by writing data
Put this part of the thread also can share pressure

CodePudding user response:

With the command batch import SQL statements

CodePudding user response:

The insert statement Prepare it

CodePudding user response:

If confirmed is the database insert lead to slow.. Whether can consider to separate the functions.
The main program receives the statement dump into text. This should be no problem. Put them in a folder.
Auxiliary again a small program. Timing from the folder and import the text database. Delete the current text after a successful import...

CodePudding user response:

[img=https://forum.csdn.net/PointForum/ui/scripts/csdn/Plugin/003/onion/1.gif] [/img x

How much you per article data

I have no pressure tested 1 k per second