RE: [phpOpenTracker-User] Speeding up OpenTracker Reporting

1.2 ghz ITOX rack mount 512 ram running Free BSD with MySQL version
3.23.52 and delay_key_write enabled.  This is a dedicated database
server.

-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of
Jean-Christian Imbeault
Sent: Thursday, September 25, 2003 6:47 PM
To: [email protected]
Subject: 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
_______________________________________________
Phpopencounter-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/phpopencounter-user





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