pomogite novichky !

est" SP kotoraia zapiciviet resyl'tat query v #Temp table
( ia delay paging )
a pootm resyl"tati vibiraytcia iz #Temp table v zavicimocti ot nomera stranici

voproc : kak optimizirovat" ?
zapic' v #Temp table i pocledyushui select iz nego ( v #Temp table est pole identity - clustered index )
zamedliayt vcu SP

ochen" medlenno rabotaet

pomogite pls !!!!

vot chto y menia proicxodit :

1) CREATE TABLE [dbo].[#Temp_search1] (
[ID] [int] IDENTITY (1, 1) ,
[rank] [int] NULL ,
] [varchar] (300) ,
ID] [int] not null ,
[Metadatas] [text] ,
[Autors] [char] (10) ,
[Titre] [varchar] (350) ,
[Filesize] [int] NULL ,
[concepts] [text] ,
[resume] [text] ,
[ModifDate] [varchar] (50) ,
[ContentCache] [text] ,
[Occurance_1] [int] ,
[Occurance_2] [int] ,
[Occurance_3] [int] ,
[Occurance_4] [int]
)
2)
insert into #Temp_search1
( rank , url , urlid , metadatas , autors , titre , filesize , concepts , resume , modifdate , contentcache , occurance_1 , occurance_2 , occurance_3 , occurance_4 )

SELECT rank , url, urlid, Metadatas, autors , titre, filesize, concepts, resume, modifdate , contentcache , Occurance_1 =
( select sum(dbo.fcount(Newprinfo.text_chunk ,'paiement de facture' ) ) from newprinfo where newprinfo.urlid = FT_TBL.UrlID
group by newprinfo.urlid ) ,
Occurance_2=
( select sum(dbo.fcount(Newprinfo.text_chunk ,'guichet automatique ' ) ) from newprinfo where newprinfo.urlid = FT_TBL.UrlID
group by newprinfo.urlid ) ,
Occurance_3=
( select sum(dbo.fcount(Newprinfo.text_chunk ,'facture au guichet automatique' ) ) from newprinfo where newprinfo.urlid = FT_TBL.UrlID
group by newprinfo.urlid ) ,
Occurance_4=
( select sum(dbo.fcount(Newprinfo.text_chunk ,'paiement de facture au guichet automatique' ) ) from newprinfo where newprinfo.urlid = FT_TBL.UrlID
group by newprinfo.urlid ) FROM url AS FT_TBL, containstable(url, contentlemmes,'ISABOUT("paiement de facture" weight (1.0) , "paiement de facture au guichet automatique" weight (1.0),
"facture au guichet automatique" weight (1.0) ,"guichet automatique" weight (1.0) )') AS KEY_TBL WHERE FT_TBL.UrlID = KEY_TBL.[KEY] AND url like '%fr%' ORDER BY occurance_1 desc ,occurance_2 desc ,occurance_3 desc, occurance_4 desc


3) zaklychitel"naia viborka is #Temp_search i paging :

SELECT
ID , rank,url ,UrlID,Metadatas ,Autors,Titre ,Filesize,concepts,resume,ModifDate,ContentCache ,Occurance_1 , occurance_2 , Occurance_3 ,occurance_4
, MoreRecords =
(
SELECT COUNT(id)
FROM #Temp_search1 TI
WHERE TI.ID >= @LastRec
)

FROM #Temp_search1
WHERE ID > @FirstRec AND ID < @LastRec



vce rabotaet ochen' medlenno , poriadka 1 min
a nado pobistree

ne podkashete kak optimisirovat" ????

ia protestirovala c function i bez nee
raznici pochti net ( 2 ces )