Low Performance

pourreza wrote:

Hi to all
I have a problem to join a table and a view. My table and view each has
150000
records. When I join these it takes about 30sec. How can improve
performance.

1. Use EXPLAIN on the join and add indexes where appropriate
2. Use a join that returns less rows
3. Use a faster computer or increase buffer size
4. Redesign your tables.
5. Tell us more about your setup and tables/views

----------------
Hannu