Execution History search is painfully slow

[Sunapee]

Alpha would be great! Looking forward to it.

[Sunapee]

Just a gentle nag, checking to see if the alpha version is available yet?

[.jp]

Hello,

Thanks for the post.

Unfortunately, the alpha version is not available so far.

Best Regards.

[Sunapee]

Another gentle nag about the availability of the alpha version. Any ETA?

[dzhanhira]

Hi there,

Sorry for the delay!

Kindly note that due to the russian aggression into Ukraine, it takes more time to respond as far as our main offices are in Ukraine.

Currently, our ETA is the 3rd quarter of 2022.

Best regards from Ukraine,
Devart Support Team

[Sunapee]

Ugh! I feel for you, hope everything works out.

[Sunapee]

Are we still on track for Q3?

[dzhanhira]

Hi,

Kindly be informed that the fixes will be included in releases of the 7 Series of SQL Complete. It means that the changes of algorithms will be released not earlier than SQL Complete v.7.0

Currently, we are working on SQL Complete v6.12 with the support of SQL Server 2022. Previously we released SQL Complete v6.11 with the support of SSMS 19. We are developing SQL Complete in parallel with all these processes.

Unfortunately, we need to inform you that releasing the SQL Complete v7.x will take couple of months more.

[Sunapee]

Thanks for the update.

Would it be possible to make a simple change in SQL Complete v6.12 to include a "Go" button on the search instead of having it search with each mouse click change. That would allow me to set up the search I want without the penalty of multiple searches (and long waits) while I set the Start date (wait) , then End date (wait) then search text (wait).

Although this does not address the slow searches, it would allow us to use the functionality and only pay for the lethargy once.

[dzhanhira]

Thanks for your reply!

Kindly be informed that after we release 6.12, we will make a build with a button specifically for you and provide it for your use.

At the beginning of autumn, we will give you an alpha 7.0 version, as you wanted, where there will be improvements in this area, plus additionally speeding up the display of the compliment sheet and a bunch of other goodies.

Thanks again for helping us with the development of the product and being free to try the alpha.

[Sunapee]

You rock!

[Raudar]

Hi there,

Thanks for your patience. Please be informed that we are going to send you the email with the link for separate custom build which includes fix for this issue.

In case you get any other issues feel free to reply back to us.

Best regards,
Devart team

[Sunapee]

I really appreciate it!

ALthough the search itself is still slow, I am able to control when the search happens now. Big improvement!

For what it's worth, the slowness seems to be while retrieving Query Text when it contains a medium to large amount of text in it. I have conditioned myself to execute a very small query before opening and using the Execution History functionality.