Re: optimizing select on big table

[Christian Hammers <ch@xxxxxxxxxxx>]

On Fri, Mar 09, 2001 at 02:05:42PM +0200, Richard Ellerbrock wrote:
> Add another index on your timestamp column. Also, I think timestamp is a reserved word. Maybe you should rename the column to something else.
...
>   PRIMARY KEY (timestamp,hostname,interfacename)
> ) TYPE=MyISAM PACK_KEYS=1;

I realized that timestamp is my "main" column but does adding another
seperat timestamp something? The docs say that searching for the first
part of a multiple-key is fine.

bye,

 -christian-

-- 
Christian Hammers    WESTEND GmbH - Aachen und Dueren     Tel 0241/701333-0
ch@xxxxxxxxxxx     Internet & Security for Professionals    Fax 0241/911879
           WESTEND ist CISCO Systems Partner - Premium Certified

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread67766@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php