>I have query which selecting the records from table(8 mb) more than 40000.
>Its take 0.80 second
>I have a 1.4 sony vio laptp.
>I am feeling Its take time long. or it is well.
>Can any one tell me . how i can decrease time.
>
>

> thisform.container6.searche.RecordSourceType=4
>   
>     thisform.container6.searche.RecordSource = "select word,ur from dict "+;
>                " where UPPER(word) = Upper(Trim(thisform.container6.texte.Value))"+;
>                " order by word into cursor SYS(2015) nofilter"
>

Do you have an index on UPPER(word)?