Re: stats query
| From: | Lukas Kahwe Smith | Date: | Mon, 16 Oct 2006 17:23:53 +0000 |
| Subject: | Re: stats query | ||
| References: | 1 | Groups: | php.pear.webmaster |
| Request: | Send a blank email to pear-webmaster+get-5295@lists.php.net to get a copy of this message | ||
Lukas Kahwe Smith wrote:
Hi, I generated 27M downloads and 600 packages. I also added an index package/dl_when. That makes the query run snappy.potentially adding release in the index would also make sense. however this index will obviously slow down inserts .. so the alternative would be to partition the table data and keep a denormalized data set around for the old data. regards, Lukas