[plug] MySQL and Indexes: testing the speed.

Trevor Phillips T.Phillips at murdoch.edu.au
Thu Jul 18 16:44:46 WST 2002


On Thursday 18 July 2002 15:40, James Bromberger wrote:
> 
> The conclusion is that on ~ 70,000 rows you can get a 4.5 times speed
> improvment doing selects and only suffer a 10% hit during inserts (and
> probably the same during updates) by creating an index on just the first 3
> characters of a 'varchar' column, whereas a complete index on the entire
> varchar will only give you a 3.2 times speed increase at a cost of 67%
> slower during inserts (and updates?).

Hey, that's very interesting, and quite useful! I'll keep it in mind when I 
next create indexes. ^_^

I wonder how a similar analysis would fare on text strings which are unique, 
but contain similar elements (eg; an assembled table of host names, or 
Browser Agent strings).

-- 
. Trevor Phillips             -           http://jurai.murdoch.edu.au/ . 
: Web Technical Administrator     -          T.Phillips at murdoch.edu.au : 
| IT Services                        -              Murdoch University | 
 >--------------------------------------------------------------------<
| On nights such as this, evil deeds are done. And good deeds, of     /
| course. But mostly evil, on the whole.                             /
 \      -- (Terry Pratchett, Wyrd Sisters)                          /



More information about the plug mailing list