Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • in reply to: Long Running Queries #20928
    brentmi
    Member
    peterlaursen wrote on Mar 20 2006, 11:51 AM:
    I am not quite sure I understand. I can place curser in any position and it works

    Yes your correct – Uptil now I've always highlighted the queries I want executed, which explains why I've never seen the red stop icon i guess 🙄

    Quote:
    If I have multiple queries and use the 'double green arrow' icon or SHIFT+F5 it still works here

    I've always got a very full/busy query window and would not normally want to execute all queries.

    Quote:
    But I confirm that it does not works with highlighted queries! And this I must consider a bug.

    Would be great to be able to highlight queries I want executed and have the “stop button” available.

    Thanks for your help – will purchase the pro version shortly 😀

    in reply to: Long Running Queries #20926
    brentmi
    Member
    Code:
    select *,from_unixtime(log_time) from BTS_MAC_metrics where bts_id = 200291 and log_time > unix_timestamp('2006-03-20 00:00:00')

    or

    Code:
    select count(*) from BTS_MAC_metrics

    As an example the count(*) query takes around 1 minute to complete as there are around 20million records. During that execution period, (same for the 1st query above also), the green arrow never changes. I run all my queries in the “query tab”

    thanks..

    Ok appear to have resolved part of the issue. The red stop icon only appears if you start you query with the curser at the beginning of the line and the query window only contains 1 query. Does not seem to work if you have multiple or highlighted queries. Is this normal or is should the red icon appear no matter what the execution mode?

    in reply to: Long Running Queries #20924
    brentmi
    Member
    peterlaursen wrote on Mar 20 2006, 08:38 AM:
    Well .. the 'green arrow' icon becomes a 'red stop' icon while query is running – doesn't it?

    Any special sort of query you are talking about ?

    No thats the problem, on my version at least the green arrow remains a “green arrow” no matter how long the execution time.

Viewing 3 posts - 1 through 3 (of 3 total)