|
| Iniciado por guest, 07,oct. 2016 11:53 - 3 respuestas |
| |
| | | |
|
| |
| Publicado el 07,octubre 2016 - 11:53 |
Hello everyone !!
I need to export a table to SQLite from fic file . The fic file contains around 100000 rows with some columns with encrypted text (binary data) . Any suggestion !!
I tried HAdd (tablename) after connecting to sqlite with native access.
It takes around one hour to add 1000 rows.
There must be some alternatives !!
Thanks !! |
| |
| |
| | | |
|
| | |
| |
| Publicado el 07,octubre 2016 - 12:41 |
Hi,
use HTransactionStart en HTransactionEnd and put all your HAdd's in between. That should speed up things.
Otherwise Windev (or sqlite) is wrapping EVERY HAdd with a transaction and that is very slow indeed. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 07,octubre 2016 - 12:53 |
Hi,
Is there a way to drop your indexes from the SQLite database before you start the import? This would probably speed it up too if its possible.
Thanks
Ned! |
| |
| |
| | | |
|
| | |
| |
| Publicado el 12,octubre 2016 - 06:35 |
Hello Binod,
Why not build queries based on the data in HFSQL .FIC file and then execute the queries on SQLite.
This would be faster.
For better memory management and good performance try to create a batch of around 1000 rows queries and execute them. Then again build another set of queries and so on....
HTH
Yogi Yang |
| |
| |
| | | |
|
| | | | |
| | |
|