Re: [fpc-pascal] sqldb, copy table between databases is painfully slow

2025-02-18 Thread Luca Olivetti via fpc-pascal
El 18/2/25 a les 14:49, Michael Van Canneyt via fpc-pascal ha escrit: On Tue, 18 Feb 2025, Luca Olivetti via fpc-pascal wrote: Hello, I need to copy a table between an mssql database and a postgresql one. I used a query to obtain the data, a datasource ponting to it and another query using

Re: [fpc-pascal] sqldb, copy table between databases is painfully slow

2025-02-18 Thread Michael Van Canneyt via fpc-pascal
On Tue, 18 Feb 2025, Luca Olivetti via fpc-pascal wrote: Hello, I need to copy a table between an mssql database and a postgresql one. I used a query to obtain the data, a datasource ponting to it and another query using the datasource, the sql being INSERT INTO table (f1,f2,f3...) value

[fpc-pascal] sqldb, copy table between databases is painfully slow

2025-02-18 Thread Luca Olivetti via fpc-pascal
Hello, I need to copy a table between an mssql database and a postgresql one. I used a query to obtain the data, a datasource ponting to it and another query using the datasource, the sql being INSERT INTO table (f1,f2,f3...) values (:f1,:f2,:f3,) and then doing OrigTable.Open; P