Execution History search is painfully slow
Execution History search is painfully slow
Searching Execution History for keywords has always been very quick. In the last couple of SQL Complete versions it has degraded to taking 15 or more seconds for a simply search. Searching for "Update" when the date filter is set for today and the total records for the day is 166.
I am using SSMS 18.9.2
Any suggestions?
I am using SSMS 18.9.2
Any suggestions?
Re: Execution History search is painfully slow
We will investigate this issue and will answer you as soon as possible.
Re: Execution History search is painfully slow
Unfortunately, we were not able to reproduce tis issue.
Could you please specify what version of dbForge you are using?
Also, please perform the following:
1. Turn on tracing by selecting 'SQL Complete -> Trace -> Start Tracing' from the main menu.
2. Reproduce the issue and send us the *.log file with the latest date from the folder:
A video or screenshots would be of help.
You can send the reply straight to our support system at supportATdevartDOTcom.
Could you please specify what version of dbForge you are using?
Also, please perform the following:
1. Turn on tracing by selecting 'SQL Complete -> Trace -> Start Tracing' from the main menu.
2. Reproduce the issue and send us the *.log file with the latest date from the folder:
Code: Select all
%SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\dbForge SQL Complete\
You can send the reply straight to our support system at supportATdevartDOTcom.
Re: Execution History search is painfully slow
Thanks for your help. I just sent the email
Re: Execution History search is painfully slow
Thank you for the reply.
We will investigate this issue.
We will investigate this issue.
Re: Execution History search is painfully slow
We were able to reproduce this issue and will fix it in the next product build.
We will notify you once it's available for downloading.
We will notify you once it's available for downloading.
Re: Execution History search is painfully slow
Sorry to say it's back.
The only thing that has changed here is that I am now on v6.9.28. When I first upgraded, searches were coming back relatively quick. Now it is taking a couple of minutes again.
Any suggestions?
The only thing that has changed here is that I am now on v6.9.28. When I first upgraded, searches were coming back relatively quick. Now it is taking a couple of minutes again.
Any suggestions?
Re: Execution History search is painfully slow
Hi there!
To reproduce this case we need to have a database ExecutedQueries.db %appdata%\Devart\dbForge SQL Complete\ExecutedQueries and please explain what and how you was doing with a detailed explanation.
To reproduce this case we need to have a database ExecutedQueries.db %appdata%\Devart\dbForge SQL Complete\ExecutedQueries and please explain what and how you was doing with a detailed explanation.
Re: Execution History search is painfully slow
I will email you the file (Don't see where I can attach one here) and details.
Re: Execution History search is painfully slow
Hi there!
Just want to duplicate the information:
we have received your email and now we keep investigate your case and once there is an update, we will inform you.
Just want to duplicate the information:
we have received your email and now we keep investigate your case and once there is an update, we will inform you.
Re: Execution History search is painfully slow
I appreciate you looking into this. If nothing else, adding a GO button as opposed to every change I make immediately starting a new search would be wonderful.
Re: Execution History search is painfully slow
I'm checking in to see if anyone has been able to look at this and/or provide an ETA? If the performance issue isn't on your radar at this juncture, I would like to re-enforce that some sort of "Go" or 'Search" button would go a LONG way.
Re: Execution History search is painfully slow
Hi there,
Kindly be informed that improvements are planned for version 7.0 and we can provide you with an alpha version
approximately in a month. The official version will be released approximately in a couple of months. Anyway, if you need an alpha one. just let us know.
Kindly be informed that improvements are planned for version 7.0 and we can provide you with an alpha version
approximately in a month. The official version will be released approximately in a couple of months. Anyway, if you need an alpha one. just let us know.