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
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 use
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
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 changi
...
>>>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
>
>
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 u
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
...
>
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
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:
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 mult
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 mult
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 parser
12 matches
Mail list logo
