Hi,
We have a server with 2 xeon cpu's, 1GB Ram, Raid, FB 1.5.1.
If we start a Query with sub-queries like follow,
we have 50% cpu usage and unusable for other users.
Is there any way to optimize FB Server?
Kadri.

-----------------------------------------------
STOK has ~ 100000 records
STOK_ISLEM has ~ 246000 records
the query
-----------------------------------------------
select
s.kod,
s.kod2,
s.kod3,
s.model,
s.renk,
s.ozel1,
s.beden,
s.grupadi,
s.saticiadi,
s.alisfiyati,
(select sum(miktar)from stok_islem
where depokod =:Depo and tarih<=:SonTarih and stoksirano = s.sirano)as
kalan,
((select sum(miktar) from stok_islem
where depokod =:Depo and tarih<=:SonTarih and stoksirano = s.sirano) *
s.alisfiyati) as tutar,
s.alisdoviz as doviz
from stok s
where s.departman = 'Deri'
order by s.kod