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
[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
