pcsoft.us.windevCopyright 2026, PC SOFT28 Mar 2016 08:10:00 Z25 Mar 2016 15:35:00 ZHello, I am using php4WM library to fetch data from remote MySQL server. This part is working fine. But when I have to insert the data retrieved from MySQL server to local SQLite database, things are becoming very slow and this process is taking very long time. Is there any way to insert the data retrieved from server in a faster manner in SQLite? TIA Yogi Yang30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57032-how-insert-data-sqlite-from-remote-mysql/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57032-how-insert-data-sqlite-from-remote-mysql-57059/read.awp28 Mar 2016 08:10:00 ZHello Arie, Thanks for the tip. You last idea is a good one... If trying the Transaction things does not work then I wi…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57032-how-insert-data-sqlite-from-remote-mysql-57059/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57032-how-insert-data-sqlite-from-remote-mysql-57059/read.awp[WM] - How to insert data in SQLite from a remote MySQLguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57032-how-insert-data-sqlite-from-remote-mysql-57035/read.awp25 Mar 2016 15:59:00 ZYogi Yang, I had the same problem. WM is wrapping each individual HAdd() in a transaction. to avoid that use SQLTransaction(…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57032-how-insert-data-sqlite-from-remote-mysql-57035/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/57032-how-insert-data-sqlite-from-remote-mysql-57035/read.awp[WM] - How to insert data in SQLite from a remote MySQL