WSG v5.560
30.03.2007  15:00         1548288 wsg5560.exe

1) Для ускорения поиска по таблице FILELIST (на массивах записей > 25000) в WSG изменен SQL-запрос выборки данных (select в select-е) для таблиц с полем TEND
 (в запросах t1, t2 - левая и правая границы интервала,
  t3=t1-12*3600
  t4=t1+12*3600):

select TBEGIN, SPS, TQTY, DATATYPE, FOFF, CPATH, CALIB, CALPER
 from (select * 
	from  FILELIST
	where STA='%s' and CH='%s'
		 and (LCODE='%s' or LCODE Is Null )
		 and (TBEGIN>t3) and (TBEGIN<t4)
	) as tmp_filelist
 where (TEND>=t1 and TBEGIN<=t2)
 order by TBEGIN

Остальные запросы  не изменены:

- для таблиц без поля TEND и "пустым" LCODE:
select TBEGIN, SPS, TQTY, DATATYPE, FOFF, CPATH, CALIB, CALPER
 from FILELIST
 where STA='%s' and CH='%s'
	 and (LCODE='%s' or LCODE Is Null)
	 and  (TBEGIN<=t1 and TBEGIN+TQTY>=t2 or TBEGIN>=t3 and TBEGIN<=t4)
 order by TBEGIN

- для таблиц без поля TEND и определенным LCODE:
select TBEGIN, SPS, TQTY, DATATYPE, FOFF, CPATH, CALIB, CALPER
 from FILELIST
 where STA='%s' and CH='%s'
	 and LCODE='%s'
	 and (TBEGIN<=t1 and TBEGIN+TQTY>=t2 or TBEGIN>=t3 and TBEGIN<=t4)
 order by TBEGIN

- для таблиц с полем TEND и определенным LCODE:
select TBEGIN, SPS, TQTY, DATATYPE, FOFF, CPATH, CALIB, CALPER
 from FILELIST
 where STA='%s' and CH='%s'
	 and LCODE='%s'
	 and (TEND>=t1 and TBEGIN<=t2)
 order by TBEGIN

Запрос для вторичной базе (таблица wfdisc) также не изменен:

select time, samprate, nsamp, datatype, foff, dir, dfile, calib, calper
 from wfdisc
 where sta='%s' and chan='%s'
	 and ( time<=t1 and endtime>=t2 or time>=t3 and time<=t4)
 order by time