@alex. wrote:
I have a tdms file around 10M, it need to import the data into center sql database.
If you say you need to import it then you probably need to import it. There could be legacy reasons to do that. However if this is a new project I would recommend not putting such large files in the database. I admin a database with thousands upon thousands of files that are about 10K to 40K in size. Initially I was putting them in the database which worked fine. The server just ran and there were no issues. It can handle this with no problems.
The issue is backups. I do a nightly dump of the db and the file size was just unmanagable so I made a change long ago. I store the files in the filesystem and filename in the database.
In addition the files are served by a webserver. This meant that Apache had to do a query every time and the browser could not take advantage of built in caching. For backing up the files I just use rsync.
Ok none of that is related to your immediate problem but I just wanted to throw that out for you and for anyone else considering saving large files in a database. Even with a big iron server there may be other issues to consider.
Just my twenty cents.
=====================
LabVIEW 2012
