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/
---------------------------------------------------------------------
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