On Tue, Mar 15, 2005, Geo Carncross <[EMAIL PROTECTED]> said: > On Tue, 2005-03-15 at 13:55 +0100, Thomas Mueller wrote:
>> Could you please post results? >> 0,04 ms per result in case of the 42k rows - that sounds like a >> in-memory database. > > My entire dbmail db is only about 50M per 12k messages; I can easily fit > 42k messages into buffer-space. Indeed, mine's entirely in memory: USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND mysql 16 0 821m 566m 7540 S 0.0 18.6 0:02.72 mysqld I could start up a slave session with caching turned down to default 64M and test on that, but I won't have time till the weekend. Aaron
