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


Sat, 27 Mar 1999 12:00:07 +0430
pourreza <pourreza@linux.ce.sharif.ac.ir>
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

Sat, 24 Apr 1999 16:51:33 +0300
Hannu Krosing <hannu@trust.ee>
Re: [HACKERS] Low Performance