| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Ronan Lucio | Date: | November 22 2005 1:44pm |
| Subject: | Re: Tips for better performance | ||
| View as plain text | |||
Martijn, >> I have a table with 5,000,000 records that takes about 1 second >> to show the results. > > All rows? No. The queries return an average of 30 rows. I just wanted to say that the problem isn´t the table size, but the query X indexes used. Ronan
| Thread | ||
|---|---|---|
| • Tips for better performance | Marko Knezevic | 22 Nov |
| • Re: Tips for better performance | Duncan Hill | 22 Nov |
| • Re: Tips for better performance | Scott Haneda | 22 Nov |
| • Re: Tips for better performance | Marko Knezevic | 22 Nov |
| • Re: Tips for better performance | Duncan Hill | 22 Nov |
| • Re: Tips for better performance | Ronan Lucio | 22 Nov |
| • Re: Tips for better performance | Martijn Tonies | 22 Nov |
| • Re: Tips for better performance | Ronan Lucio | 22 Nov |
| • Re: Tips for better performance | Martijn Tonies | 22 Nov |
| • Re: Tips for better performance | Marko Knezevic | 22 Nov |
| • Re: Tips for better performance | Marko Knezevic | 22 Nov |
| • Re: Tips for better performance | Dan Baker | 22 Nov |
| • Re: Tips for better performance | Ronan Lucio | 23 Nov |
| • Re: Tips for better performance | Marko Knezevic | 23 Nov |
| • Re: Tips for better performance | Marko Knezevic | 23 Nov |
| • Re: Tips for better performance | Ronan Lucio | 23 Nov |
