|
Replies:
5
-
Pages:
1
-
Last Post:
Oct 1, 2009 8:12 PM
by: Alex Luk
|
|
|
Posts:
34
Registered:
1/27/09
|
|
|
|
limit CPU consumption ??
Posted:
Aug 27, 2009 11:10 AM
|
|
|
From the doc "I like the new feature where The optimization process now returns each alternative SQL statement as soon as it is generated. The execution of the original SQL and the alternatives can also beautomatically started during the optimization process so that you cancomplete the SQL generation and testing process more quickly."
but is there any way in the beta software or any settings where you can execute the sql after everything has been generated ?? As at times it is consuming a lot of cpu and memory when generating the alternatives. or any settings to limit cpu consumptions ? As couple of times it crashed and didnt even let me generate a support bundlle for you guys. I am on vista 64Bit.
|
|
|
Posts:
62
Registered:
9/25/06
|
|
|
|
Re: limit CPU consumption ??
Posted:
Aug 28, 2009 5:53 AM
in response to: crazy
|
|
|
Hi,
Thank you for the feedback.
If you would like to get only the alternatives without starting the test run, you can click on the Rewrite button. This button will give you the same rewrites generated by Optimize, but not executing any SQL for you. After the alternatives generated, you can use the Batch Run button to start the test run. Hope this help.
Regarding the high resource consumption because of the simultaneous rewrite and test run processes, we are awared of that and we are consistently tuning this. No guarantee that it will be all fixed in the final release but I hope that it would be improved by the time we have the final build.
Thanks.
|
|
|
Posts:
34
Registered:
1/27/09
|
|
|
|
Re: limit CPU consumption ??
Posted:
Aug 29, 2009 1:08 PM
in response to: Alex Luk
|
|
|
Thanks for the response Alex. But it would be great to limit the cput consumption, as there are other things you want to run on ur computer. I am sure you guys probably came up with this idea...but a suggestion would be.....instead of throwing alt's sql when they are produce....wait and throw 10 - 20 sql alt at a time....instaead of when they are produce...if you know what i mean...
|
|
|
Posts:
62
Registered:
9/25/06
|
|
|
|
Re: limit CPU consumption ??
Posted:
Aug 31, 2009 6:33 AM
in response to: crazy
|
|
|
Thank you. We are looking at that direction also.
|
|
|
Posts:
34
Registered:
1/27/09
|
|
|
|
Re: limit CPU consumption ??
Posted:
Oct 1, 2009 8:01 PM
in response to: Alex Luk
|
|
|
When is 7.5 suppose to release ?? I thought it was suppose to releast Oct 1st...Just curious when it is suppose to relase ?
|
|
|
Posts:
62
Registered:
9/25/06
|
|
|
|
Re: limit CPU consumption ??
Posted:
Oct 1, 2009 8:12 PM
in response to: crazy
|
|
|
Yes, it went GA on Oct 1st. The new release 7.5 should already be availalbe to download under Support Link (In www.quest.com, go to Support | Downloads and Updates). If you have problem access it, please contact Quest Support to get help. They would be happy to assist you.
Thanks.
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
