--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

>
> > > SELECT
> > > (select count(ss.user_name) from USER ss) as "COUNT",
> > > u.user_name,
> > > u.password
> > > FROM USER u;
> > >
> > > /hb
> >
> > it method is lower performance
>
> but, but ... yours doesn't work. How can it have lower
> performance?
>
> With regards,
>
> Martijn Tonies

"it method is low performance"

my English language ;) excuse me.

my method currently is (low performance and paradox):



qryHaber (Datasource=ibbfuse, Time=2328ms, Records=11) in
G:\Intranet\Test\ibb_gov_tr\ferse\arama\index.cfm @ 19:08:44.044

SELECT
(
SELECT COUNT (*)
FROM ICERIK
WHERE
SIRA = 1
AND
ICERIK_ID IN
(
SELECT
ICERIK_ID
FROM ICERIK
WHERE
DURUM=5
AND DIL=0
AND TURU=42
AND NESNE IN
(1,3,5,8)
AND
(

0=1 OR ( 0=1 OR tupper(PARAM_1) LIKE tupper('%ali%') OR tupper
(METIN) LIKE tupper('%ali%') )
)
)
) AS ADET, SATIR_SIRA_NO, ICERIK_ID, BASLIK, OZET,
ILGILI_TARIH
FROM
(
SELECT ROWNUM as SATIR_SIRA_NO, ICERIK_ID, PARAM_1
AS BASLIK, METIN AS OZET, ILGILI_TARIH
FROM ICERIK
WHERE
SIRA = 1
AND
ROWNUM <= 40
AND
ICERIK_ID IN
(
SELECT
ICERIK_ID
FROM ICERIK
WHERE
DURUM=5
AND DIL=0
AND
TURU=42
AND
NESNE IN (1,3,5,8)

AND

(

0=1 OR ( 0=1 OR tupper(PARAM_1) LIKE tupper('%ali%') OR
tupper(METIN) LIKE tupper('%ali%') )

)
)
)
WHERE
SATIR_SIRA_NO >= 30