joseph wrote:
> sorry, i made a mistake before.
>
>
>>> 9795 Query select
>>>word,def,wordid,pos,posn,wordsize,syn from korean_english where word
>>>like '운전할' order by wordsize desc
>>
>>in cases when you are not using the wildcard tokens (percentage signs)
>>try changing the query to use something like:
>>
>> ... word = '운전할' ...
>>
>
>
> i have to stick with 'like' because it matches case-insensitive, else
> the first word of a sentence (with a capital letter) doesn't match the
> db word. FYI
do you really care about case (in languages where characters even have case)?
if not stick everything into the DB as uppercase and test against that (always
normalizing
everything to uppercase before doing the queries). it would be faster than a
case-insensitive search
also consider it might be worth creating a special index for the first (couple?)
of letters of the WORD field, that would allow something like this (not in all
cases obviously):
SELECT * FROM korean_english WHERE word = '운전할' AND SUBSTR(word,0,1) =
'운'
(now I'm allowed to sue 'SELECT * ...' because I'm offering a possible
concept/idea - as opposed to pasting code for people look at) - basically the
idea
entails creating an index (possibly based on an extra column) that would allow
the
mysql engine to start searching in a smaller subset based on the 2nd (in this
case)
WHERE clause and using the more compact 'SUBSTR(word,0,1)' index.
this might not have any effect whatsoever depending on how indexes are used
internally by the mysql engine. so basically this is me guessing :-)
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
