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