Thread: Low Performance

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.
Regards
Hossein

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