Ответ

Elvis 17.01.2004 00:16

вот кусок кода который тормозит

$records[^table::sql{select abonentid,nach from $MAIN:nachtab where date="$period"}]
^void:sql{delete from $MAIN:nachTemp}
^records.menu{
$ABONENT_Fields[^table::sql{select po,aboncode,tarifid,apt,name,lastname,secondname,notvod,tel,houseid from $MAIN:abtab where id="$records.abonentid"}]
$HOUSE_Fields[^table::sql{select number,name from $MAIN:housestab left join $MAIN:streetstab on(${MAIN:housestab}.streetid=${MAIN:streetstab}.id) where ${MAIN:housestab}.id="$ABONENT_Fields.houseid"}]

^void:sql{
$po($ABONENT_Fields.po)
$houseid[$ABONENT_Fields.houseid]
$houseid[^houseid.format[%04d]]
$nchanells(^int:sql{select count(*) from $MAIN:t_c_tab left join $MAIN:chanellstab on(${MAIN:t_c_tab}.chanellid = ${MAIN:chanellstab}.id) where ${MAIN:t_c_tab}.tarifid = "$ABONENT_Fields.tarifid"})

$zaplatil(^double:sql{select sum(summ) from $MAIN:paystab where aboncode="$ABONENT_Fields.aboncode"})
$nachisleno(^double:sql{select sum(nach) from $MAIN:nachtab where abonentid="$records.abonentid" and date<"$period"})
$dolg($nachisleno-$zaplatil)

insert into ${MAIN:nachTemp}(po,houseid,nchanells,aboncode,street,number,apt,fio,tel,podkl,nach,dolg,owner,notvod)
values('$po','$houseid','$nchanells','$ABONENT_Fields.aboncode','$HOUSE_Fields.name','$HOUSE_Fields.number','$ABONENT_Fields.apt','$ABONENT_Fields.lastname $ABONENT_Fields.name $ABONENT_Fields.secondname','$ABONENT_Fields.tel','','$records.nach','$dolg','','$ABONENT_Fields.notvod')
}

}

---