Hi!
> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> It's a pity what mysql misses something like PROFILE call for the
Peter> query so I could check how much time is spent for different phases of
Peter> query execution.
MW> Any suggestions for the output for this?
Peter> W
Hello Michael,
Sunday, April 08, 2001, 4:21:18 AM, you wrote:
Peter>> No it's not but it has just a couple of collisions per 100.000
Peter>> records.
MW> The problem with a not unique key is that MySQL will do an extra check
MW> if it should use the key during the optimization stage. If the
Hello Tim,
Saturday, April 07, 2001, 3:21:52 AM, you wrote:
>> The reason singly queries are slower are of course that the
>> initialization phase (reading the data from a socket, parsing,
>> locking, checking which keys to use) is about half of the query time.
>>
>> Peter> Heikki made tests
