Matthias Urlichs writes:
> Hi,
>
> Sinisa Milivojevic:
> > First of all, where have you got 3.23.34 when it is not out ??
> >
> It's the version in your current BitKeeper archive.
>
> > Second what type of column is id and what does PRIMARY KEY consist of.
> >
> >>> explain ticketid;
> Field Type Null Key Default Extra
> id varchar(100) PRI
> ticket int(11) MUL 0
> sender int(11) MUL 0
> added int(11) YES <NULL>
> seq int(11) 0
> extern char(1) YES <NULL>
> inhalt mediumtext YES <NULL>
> typ smallint(6) YES <NULL>
> d_data int(11) YES <NULL>
>
> >>> show index from ticketid;
> Table Non_unique Key_name Seq_in_index Column_name Collation
> ticketid 0 PRIMARY 1 id A
> ticketid 1 ticket 1 ticket A
> ticketid 1 ticket 2 seq A
> ticketid 1 sender_i 1 sender A
>
> > Third --with-debug is slower then without.
> >
> But not that much slower...
>
> --
> Matthias Urlichs | noris network AG | http://smurf.noris.de/
>
After taking a look at your table, the answer to your question is
YES. varchar(100) is too large for index.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
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