hi oleg;

thanks for your idea, but i have tried your way and it still give me the
same range on searching time?

----- Original Message -----
From: "Oleg Kapeljushnik" <c-oleg.kapeljushnik@w...>
To: "JavaScript HowTo" <javascript_howto@p...>
Sent: Friday, May 03, 2002 8:20 PM
Subject: [javascript_howto] RE: use in


> I know that IN is not very efficient.
> You can try use it like this :
>
> sql="select * from invmarc where number in (select DISTINCT val(number)
from
> keyword where " &  _
>   tstr  & " and (
> tag ='100' or
> tag ='110' or
> tag ='240' or
> tag ='245' or
> tag ='440' or
> tag ='490' or
> tag ='505' or
> tag ='520' or
> tag ='600' or
> tag ='610' or
> tag ='650' or
> tag ='651' or
> tag ='700' or
> tag ='710' or
> tag ='730' or
> tag ='740' or
> tag ='810' or
> tag ='830')) "
>
> its a longer one but try this may be it will improve your performance.
>
> Oleg.
>
> -----Original Message-----
> From: Tan Yoke Yew [mailto:yytan@e...]
> Sent: May 03, 2002 4:16 AM
> To: JavaScript HowTo
> Cc: bharatsaboo@h...
> Subject: [javascript_howto] use in
>
>
> hi there;
>
> i have another question, regarding the search result.
>
> base on the sql below, it take about >10 second to display the result. is
it
> possible to make the search faster?
>
> sql="select * from invmarc where number in (select DISTINCT val(number)
from
> keyword where " &  _
>   tstr  & " and tag in
>
('100','110','240','245','440','490','505','520','600','610','650','651','70
> 0','710','730','740','810','830')) "
>
>
>
>
>
> ---
>
> Improve your web design skills with these new books from Glasshaus.
>
> Usable Web Menus
> http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
> r-20
> Constructing Accessible Web Sites
> http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
> r-20
> Practical JavaScript for the Usable Web
> http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
> r-20
>
>
>
> ---
>
> Improve your web design skills with these new books from Glasshaus.
>
> Usable Web Menus
> http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
> r-20
> Constructing Accessible Web Sites
> http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
> r-20
> Practical JavaScript for the Usable Web
> http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
> r-20
>
>