Re: [phpOpenTracker-User] Speeding up OpenTracker Reporting

Christopher Hogan wrote:

> This is the same problem I'm experiencing.  Our production site ranked
> 23,021 page views today so far, and the only way I've been able to
> generate reports is via custom code.

[...]
> 
> But on campaigns where document exceeds 20,000 for the month, generating
> a list of all the ads in the time frame takes more than 2 minutes.

Thanks for posting your problems. Since no one else had mentionned
issues like this on the mailing list I was beginning to think that I
might be the only one experienceing these same issues.

Can I ask what kind of hardware you are using for your database, which
database (MySQL, PostgreSQL, Oracle?) and is it a dedicated server?

Jc



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf