APEL FAQs

Setting query timeout

Sometimes query takes a lot of time to execute. To see current timeout:

 rgma> show timeout
 Timeout: 1 minutes

To increase the timeout:

 SET TIMEOUT 3 minutes

Checking data

To see what dates were published issue the following query (modifying the date):

 SELECT MeasurementDate, count(*) from LcgRecords WHERE ExecutingSite='T2_Estonia' and MeasurementDate >= '2008-07-20' GROUP BY MeasurementDate ORDER BY MeasurementDate;