Page 1 of 1

graceful timeout

Posted: Thu Jul 30, 2009 5:13 am
by gaurav.shetti
Is there a mechanism where in I can gracefully stop the vortex script from fetching the results any more results from texis database and proceed with other execution.

As in .. if i have

<a name=main>
<sql ..... ></sql>
//other functions
</a>

If sql is taking a lot of time to fetch the results. The sql is not a row statement. It will fetch all the results and insert it into a temporary table. That table will then be sorted by a ranking mechanism which we have. Is there any method wherein i can simply stop the script and make it to display all the results it has fetched so far when the script is taking a lot of time to execute.

graceful timeout

Posted: Thu Jul 30, 2009 10:29 am
by mark
<sql> itself doesn't have a timeout setting but you could use <sysinfo time> inside the <sql> loop and <break> after your desired interval. Just make sure the overall script timeout is longer than your sql interval.