search

datacleaner / DataCleaner

The premier open source Data Quality solution
GNU Lesser General Public License v3.0
598 stars 181 forks source link

DataCleaner slows down when working with Oracle database with lots of services #1403

Open arjansh opened 8 years ago

arjansh commented 8 years ago

I have configured a data store which connects to an Oracle database which provides over 40 services. Based on the configuration of the data store I should only be able to use one of these services. When I build a job using this data store all services provided by the Oracle database are shown, while I would only expect to see the one I configured to use. This is not my main issue here however, my main issue is that when I now search the component library, by using the search box in the bottom left, nothing happens for a while (up to a few minutes), the text I typed (e.g. "table" appears and the components containing that text are shown as filtered results in the component library.

LosD commented 8 years ago

I think this is a symptom of a more general problem with the library. I also frequently see slowdowns in the library. We might need away to assure that a new lookup isn't done every single time the tree changes, possibly using some caching.