joseph wrote:
hi,
my site is www.myowndictionary.com
i use javascript to create definitions for words (from open source
dictionaries) as pop-ups and hook word-lists for vocabulary study with
that.
i can now parse the html from rss feeds and match only text of interest.
i just wrote my own
fellow php programmers,
sorry to you two who were kind enough to take the time to attempt to
answer my question. i thought it was enough to say i had 550 lines
with a bunch of sql calls and loops and big data structures
to help you make a better assessment i will summarize in more detail
now.
joseph wrote:
fellow php programmers,
sorry to you two who were kind enough to take the time to attempt to
answer my question. i thought it was enough to say i had 550 lines
with a bunch of sql calls and loops and big data structures
psychics-php is a seperate mailing lists, please
many points given to my esteemed and humble correspondant for:
1)
psychics-php is a seperate mailing lists, please channel/mindmeld the correct
subscription procedure from John Nichel ;-)
points to me for a quick comeback ( word is indexed, wordsize is not)
1) per mysql website
...
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
...
word,def,wordid,pos,posn,wordsize,syn from korean_english where word
like '운전할 %' order by wordsize desc
oh would you look at this
you're ordering by WORDSIZE.
stick an index on WORDSIZE!!!
http://dev.mysql.com/doc/refman/5.0/en/order-by-optimization.html
In some cases,
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
mr. maas,
psychic me you are a man.
i created an index, no change. but i already knew that because one of
the cases where an index is never used is when
The key used to fetch the rows is not the same as the one used in the
ORDER BY:
which is the case here.
(index creation
On Mon, Mar 13, 2006 at 10:32:55PM +0900, joseph wrote:
mr. maas,
psychic me you are a man.
i created an index, no change. but i already knew that because one of
the cases where an index is never used is when
The key used to fetch the rows is not the same as the one used in
Something that is chiefly bottlenecked at the database isn't going to be
improved enough at the C level to be worth the trouble. Always optimize
where it's slow. Database design and indexing helps. Minimizing
unnecessary queries, writing good ones, helps too.
Once you get to the point that
hi,
my site is www.myowndictionary.com
i use javascript to create definitions for words (from open source
dictionaries) as pop-ups and hook word-lists for vocabulary study with
that.
i can now parse the html from rss feeds and match only text of interest.
i just wrote my own multibyte html
joseph wrote:
hi,
my site is www.myowndictionary.com
i use javascript to create definitions for words (from open source
dictionaries) as pop-ups and hook word-lists for vocabulary study with
that.
i can now parse the html from rss feeds and match only text of interest.
i just wrote my own
12 matches
Mail list logo