Mailing List Archive


Back to the month index Back to the list index
Soorena Salari (ssalari@globalist.net)
Fri, 07 Nov 1997 22:49:18 -0800 

Message-Id: <3.0.3.32.19971107224918.007bd490@globalist.net>
Date: Fri, 07 Nov 1997 22:49:18 -0800
From: Soorena Salari <ssalari@globalist.net>
Subject: Proper use of INDEX

Hello,
We have moved from version 1.x to 2.0.3 and we trying to improve the
performance of our database. Even though we have created individual INDEXes
for 5 searchable fields in a table that has 20 fields, it still takes up to
1:40 seconds to find the result. The database has only 330,000 rows.

When searching by the City field, the cities in the end of alphabet (e.g.
New York) take as much as 2 times longer than the cities in the beginning
of alphabet (e.g. Albuquerque). Is there a sequential search on the INDEXes?

I have read some claims in the Archives that people are very satisfied with
the performance of mSQL. Is there a trick or a proper sequence to maximize
the performance? Or performance is a relative word and 1 minute and 40
seconds is acceptable for some users? I would think in case of a average
web-user, they start clicking on the reload after a few seconds.

We are using Linux-2.0.27-i586 (Red Hat) on a Pentium 200 with 72MB of RAM.

Any ideas or suggestion would be greatly appreciated.

SS
From pedda@apollo.rsn.hk-r.se Sat Nov 8 06:22:33 1997
Received: from mocha.bunyip.com (mocha.Bunyip.Com [192.197.208.1])
        by services.bunyip.com (8.8.5/8.8.5) with ESMTP id GAA20677
        for <msql-list@services.bunyip.com>; Sat, 8 Nov 1997 06:22:32 -0500 (EST)
Received: from apollo.rsn.hk-r.se (apollo.rsn.hk-r.se [194.47.150.239])
        by mocha.bunyip.com (8.8.5/8.8.5) with ESMTP id GAA17371
        for <msql-list@Bunyip.Com>; Sat, 8 Nov 1997 06:22:00 -0500 (EST)
Received: from apollo.rsn.hk-r.se (apollo.rsn.hk-r.se [194.47.150.239])
        by apollo.rsn.hk-r.se (8.8.7/8.8.5) with SMTP id MAA26015
        for <msql-list@Bunyip.Com>; Sat, 8 Nov 1997 12:41:17 +0100
Date: Sat, 8 Nov 1997 12:41:16 +0100 (MET)
From: pedda <pedda@apollo.rsn.hk-r.se>
Reply-To: Per Lanvin <Per.Lanvin@rsn.hk-r.se>
To: msql-list@Bunyip.Com
Subject: database size
In-Reply-To: <199711071829.NAA06885@services.bunyip.com>
Message-ID: <Pine.LNX.3.95.971108123935.26010A-100000@apollo.rsn.hk-r.se>
Organization: Virtual Truth Corp
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

Hello,

I wonder how big the database could grow.. is there a software limit ?

rgds

/PL