Alexander Barkov wrote:
Matthew Sullivan wrote:mysql> explain select * from ndict6 where (word_id='-175892837');
>
> Alexander Barkov wrote:
>
> > Matthew Sullivan wrote:
> > >
> > > Alexander Barkov wrote:
> > >
> > > > How many records in ndict4, ndict6 tables?
> > > >
> > > > Find an information on how to make search faster in doc/performance.txt
> > > >
> > > > Matthew Sullivan wrote:
> > > > > ndict4 contains 2051909 rows
> > > > > ndict6 contains 1415176 rows
> >
> > Big enough. Try to sort tables content as it described in
> > performance.txt
>
> Already done this... (I run optimize.sh after every db update)Check what does MySQL report for "EXPLAIN SELECT * FROM ndict4 WHERE
word_id=XXX"
Probably something wrong with indexes.
+--------+------+---------------+----------+---------+------------+------+-------+
| table | type | possible_keys | key | key_len | ref | rows | Extra |
+--------+------+---------------+----------+---------+------------+------+-------+
| ndict6 | ref | word_id6 | word_id6 | 4 | -175892837 | 2406 | |
+--------+------+---------------+----------+---------+------------+------+-------+
1 row in set (0.01 sec)
mysql>
(this is cached in memory)
mysql> explain select * from ndict7 where (word_id='2082865617');
+--------+------+---------------+----------+---------+------------+------+-------+
| table | type | possible_keys | key
| key_len | ref | rows | Extra
|
+--------+------+---------------+----------+---------+------------+------+-------+
| ndict7 | ref | word_id7 |
word_id7 | 4 | 2082865617 |
19 | |
+--------+------+---------------+----------+---------+------------+------+-------+
1 row in set (0.02 sec)
mysql>
This wasn't....
--
Yours
Matthew
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Any connection between your reality and mine is purely coincidental.
begin:vcard n:Sullivan;Matthew tel;cell:+44 (0)780 122 5744 tel;fax:+61 (0)3 9693 7699 tel;home:Ex-Directory tel;work:+61 (0)3 9693 7640 x-mozilla-html:TRUE url:http://people.netscape.com/matthews/ org:<TABLE cols=2 width=350 spacing=0 rows=1><TR><TD width=50><img src="http://people.netscape.com/matthews/penguin.gif"></TD><TD><TABLE width=250 spacing=0 border=0><TR><TD><FONT SIZE=2>Senior Technical Support Engineer<TR><TD><FONT SIZE=2>iPlanet E-Commerce Solutions<TR><TD><FONT SIZE=2>Australian Technical Support Services</TABLE></TABLE> version:2.1 email;internet:[EMAIL PROTECTED] adr;quoted-printable:;;Netscape Communications Australia=0D=0A;Level 1, The Tea House, 28 Clarendon Street;South Melbourne;VIC 3205;Australia x-mozilla-cpt:nemesis.netscape.com;-27760 fn:Matthew Sullivan end:vcard