Hi All,
Just a few thoughts to throw around - currently I am running the search to a MySQL
backend which is a Sun Ultra 10 (Single UltraSpar 440M CPU) with 1 Gig Ram and 18Gig
of drive space ....
If I login to the mysql server and connect to the database and perform a search on the
word test - using the crc-multi indexed data and the sql command:
select * from ndict4 where (word_id='-662733300');
i get: 6844 rows in set (30.97 sec)
and searching a 2nd time: 6844 rows in set (10.05 sec)
ndict4 contains 2051909 rows
if I then search on: 'customer' [select * from ndict6 where (word_id='-175892837');]
the result is: 2264 rows in set (7.51 sec)
then: 2264 rows in set (3.15 sec)
ndict6 contains 1415176 rows
TO me this seems an awfully long time to perform searches (especially on 1 word) - the
mysql server has been tuned roughly and currently consumes 400M of Physical RAM, and
there are 95000ish documents in the database - consuming 933M of disk...
Questions:
1/ would it appear that I need to tune the MySQL server further?
2/ are these search times extended or do they seem ok?
3/ is there anyway of speeding the searches up?
Using UltraSeek on the same words, the results are gathered and rendered in under 1
second (the logs report the queries takes 350ms)
--
Yours
Matthew
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
I'm really easy to get along with once you people learn to worship me.
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
S/MIME Cryptographic Signature
