Re: stats query

From: 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

« previous php.pear.webmaster (#5295) next »