Oracle set user schema for tables window

More
6 years 3 months ago #19875 by Phelps
Kudos for a great tool and hope you keep it available.
This is just a suggestion on usability, it works perfectly as is, but for the Table Incremental Search filter it might work a little faster if you do a refresh after the enter key is detected and not every OnKeyPress event. On large numbers of tables the refresh after every key press slows things down and sometimes can become non responsive. Only a suggestion :)

-Steve
Attachments:

Please Log in or Create an account to join the conversation.

More
1 year 2 months ago #25260 by alecpp
Until recently, I was working on version 5.3.2.10, but on my new computer, I installed version 5.3.3.12, encountering the problems mentioned before.
By displaying all Oracle tables and using an incremental search, the performance is significantly lower compared to the previous version I was using.
I agree with the requirement to be able to filter tables and/or change the search. Or revert it if it were the least problematic, because I believe that the old way was no less practical since all the tables were visible in the builder, anyway.
That said, I really appreciate your work.
Thank you !.
The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

More
1 year 2 months ago #25264 by admin
I had a look at the code and it exactly the same.
We do have version control here.
The code is literally 3 lines.
Perhaps your database has much more tables now?

We will try to add "Keyboard Throttling" might increase performance slightly

 

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
1 year 2 months ago - 1 year 2 months ago #25267 by admin
Can you try version 5.3.3.14 please.

If you type very fast the search will not run after every key pass but once typing is completed.
It is a little bit more complicated than that and in theory it should improve performance.

Mike
ETL Architect
Last edit: 1 year 2 months ago by admin.

Please Log in or Create an account to join the conversation.

More
1 year 2 months ago - 1 year 2 months ago #25272 by alecpp

I had a look at the code and it exactly the same.

I don't know which versions you're referring to. As mentioned at the beginning of the thread, the tables displayed seem to have changed at some point. In my case, apart from the program versions, there are no changes in the database. In fact, when I open it, each version displays different lists at the same time.

Can you try version 5.3.3.14 please.


I've downloaded and tested it.
Although I've noticed improved performance, something strange is happening: when I quickly type the name (or part of it) of the table, the attached image appears (full screen!).
t also appears when I quickly use backspace.
I have the impression this is related to a pop-up ...

 

Attachment not found

Last edit: 1 year 2 months ago by alecpp. Reason: Delete attachment
The following user(s) said Thank You: Peter.Jonson

Please Log in or Create an account to join the conversation.

More
1 year 2 months ago - 1 year 2 months ago #25273 by Peter.Jonson
I don't know which versions you're referring to. As mentioned at the beginning of the thread, the tables displayed seem to have changed at some point. In my case, apart from the program versions, there are no changes in the database. In fact, when I open it, each version displays different lists at the same time.

Does it mean that we have to fix something?


 

Peter Jonson
ETL Developer
Last edit: 1 year 2 months ago by Peter.Jonson.

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save