I’m currently testing the free version of EasyMorph Desktop to see if it fits our needs.
I’m facing an issue when importing a table from a database into EasyMorph—it takes a long time. For example, I tested importing a table with 18 columns and 1.6 million records, and it takes 7–10 minutes just to load. My PC has 64GB of RAM, so memory isn’t an issue.
The .dset option isn’t sufficient either, because I still have to import the table first and then export it as a .dset file. I also tried using the iteration method, but it’s quite complicated, and I didn’t fully understand it from the documentation.
Could you please let me know if there is a better way to load data from a database into EasyMorph more quickly? In my use case, I have many tables with a large number of records.
That’s definitely not normal.
Which database is it? do you use ODBC or is it a native connector?
How long takes the execution of the query directory on that database?
@Jochen_Marquardt
I’m using oracle database and the native connector for oracle, it’s the same thing with postgres as well, it take few seconds when querying the table on the database itself.
To be honest, I think I cannot help very much, but for me, it sounds more like a network problem or something like that.
We use both databases as sources (and targets) and none of them takes that much time even for reading or writing much more records.
I don’t have an issue in writing, and our network speed is over 60MB.
Is there a better way to load data into Easymorph, can you walk me through how to do the iteration process.
@montaser, iterations are executed sequentially, so I wouldn't expect it to speed things up.
Can you please send the table's schema to support@easymorph.com?