I'm using MySQL 5.1.30 and have several memory tables with indexes on the
appropriate columns. When I try and join 2 particular memory tables together
to get 5k rows, it takes 90 seconds.
This is incredibly slow considering table1 has 11k rows and table2 has 5k
rows. A table join like this
I'm using MySQL 5.1.30 and have several memory tables with indexes on the
appropriate columns. When I try and join 2 particular memory tables
together to get 5k rows, it takes 90 seconds.
This is incredibly slow considering table1 has 11k rows and table2 has 5k
rows. A table join like this
Memory tables use hash indexes by default instead of b-tree. Try
changing the index, that should help significantly.
regards,
Walter
On Tue, Mar 31, 2009 at 6:47 PM, mos mo...@fastmail.fm wrote:
I'm using MySQL 5.1.30 and have several memory tables with indexes on the
appropriate columns.