Visokio website     Downloads     Video tutorials     KnowledgeBase  
SQL Count query - Visokio Forums
SQL Count query
  •     WKeith November 16, 2010 4:30PM
    I noticed a comment on the 2.6 site that the "The redundant "SQL Count" field has been removed", and wondered if all that the count query was doing was allowing the percentage done to be shown when fetching data. I therefore used select count(*) from dual as a stub, to see if this would improve data fetch times when using the scheduler, and it practically halfed them. There seems to be no downside to this - am I correct?
  • 2 Comments
  •     steve November 16, 2010 4:51PM
    Yes, in fact you might be able to leave it blank. If it lets you, the worst that can happen is you'll get indeterminate progress.
  •     WKeith November 17, 2010 2:14PM
    When I leave it blank, the progress is in rows, rather than a %, and it takes half the time to process in the scheduler.

    Thanks

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership