Devart Forums

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?

We will investigate this issue and will answer you as soon as possible.

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.

Thanks for your help. I just sent the email

Thank you for the reply.

We will investigate this issue.

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.

YOU ROCK!

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?

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.

I will email you the file (Don't see where I can attach one here) and details.

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.

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.

We will take this into account.

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.

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.