On Fri, 2006-06-30 at 13:01 -0700, Tanner Postert wrote:
so we have run into another interesting problem
when i do a select * from users (35000) rows in the table.
it takes 10.67 seconds.
if i just do a select username from users it takes 0.30 seconds.
shouldn't the queries take the same amount of time, just return different
amounts of data? it the overhead of passing that data accross the network
that big? seems like a lot.
thanks for you help, and you patience
what's the schema of the table?
my guess is username is quite small compared to the rest of the table.
we only transfer the exact fields that are required across the wire (to
save bandwidth and time).
You're probably seeing this.
Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html
8 messages in com.mysql.lists.clusterRe: show tables query time
