Hello

It seems that Visual Importer Ent does not provide ADO interface support?

Radj

Radj

Yes. it does not and there is a reason for it.
There are two problems with ADO.
1. It is incredibly slow for inserts.
(50 records per sec with ADO, 2500 per sec with Oracle OCI, depending on the table)

2. When exporting data from large tables it uses all available virtual memory.
What we wanted to do is to fetch 100 records into a buffer in the memory than reuse same buffer over and over again.
Instead it kept all the records in the memory.
If you have 20GIG table think how much memory you need.
We tried to use forward only cursors it did not help either

May be ADO is much better and faster now but so far all our test proved otherwise.

Our setup is only 6MB and it works straight out of the box.
Because we did run a lot of performance tests and removed all redundant code.
and we are still working on the improvements

Best Regards,
Mike.