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=4thisform.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"