I have never been to blogger.com, let alone posted something to it.
anyone have any idea what this is about? is google trying to assimilate me
or something?
postgateway@xxxxxxxxxxx wrote:
Blogger could not process your message at this time.
Error code: 6.1C18D13
Original message:
From: jochem@xxxxxxxxxxxxx
Date: Mon, 13 Mar 2006 14:19:56 +0100
Subject: Re: what would a c extension buy me
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
