将文件数据导出到SQL [英] Export file data to SQL

问题描述

我在档案中记录了一些分隔符。我的前端是PHP。目前我在前端构建逻辑，从列文件中逐行读取数据，然后在SQL数据库中插入相同的数据。



在某种程度上，上述逻辑有效，但是当我的数据增加时，我的过程变慢了。



我想在SQL级别进行所有处理。



我怎样才能完成这项任务，因为我对PHP有些新意。





提前致谢。



干杯

Hi,

I have records in file with some delimitor. My front end is in PHP. Presently i have build logic in front end which reads data from file row wise, column wise and then insert the same in SQL database.

Till some extent the above logic is working, but when my data is increasing, my process is getting slow.

I wanted to do all processing at SQL level.

How can i achieve this task as i am bit new to PHP.


Thanks in advance.

Cheers

推荐答案

编写前端逻辑上传文件中的数据增加时文件将花费时间。因为它是在两种不同的语言SQL和PHP之间进行讨论。

我建议在SQL中编写SSIS包脚本以更快地运行上载。

Writing a front end logic to upload the file will take time as the data in the file increases. Becuase it is talking between 2 different languages SQL and PHP.
I would advise to script a SSIS package in SQL to run upload faster.

这篇关于将文件数据导出到SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！