Postgresql Insert loop execution time is too long
显示 更早的评论
Hi,
I'm currently trying to save test data into a PostGreSQL database. I loop on my table and insert my data as the following :
for i=1:size(Data,1)
exec(obj.conn,['INSERT INTO...........'])
end
The size of my data is about 234000 rows. The copy in the database take 2h30...
I'm using the database toolbox
Thank you in advance for you help !
采纳的回答
Sachin
2023-3-23
Hi
I understand that you are facing an issue with execution time. The following information might be of good help to you.
Inserting data into a PostgreSQL data row by row can be a slow process, especially if you are dealing with a large amount of data.
One way to improve the performance is to use the COPY command instead of INSERT statements.
Here is an example of how you could use the COPY command in MATLAB.
- Create a CSV file with your data.
- Use the COPY command to load the data into the database.
exec(conn, ‘COPY mytable FROM ‘/path to myData.csv’ WITH (FORMAT CSV);’
You can find more information about COPY command in PostgreSQL here :
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 PostgreSQL Native Interface 的更多信息
Translated by 
