A slight performance degradation is expected since the system performs geographic targeting. But if the difference is too much , we will look into the same. Can I have more details mentioned below.

Number of rows in ppc_ads
Number of rows in ppc_keywords
Number of rows in ad_location_mapping

Also can I know the avg. no. of daily impressions?

Also when you try to clear the data, what is the response you are getting?

Regards
Robin Paulose

December 16, 2009, 1:25 am

Private post from Arif Patmainudin

December 18, 2009, 7:00 am

Robin Paulose

Posts: 576

Re:Re:Re:Another issue

Hi Arif

We will update you soon about the performance issue.
Can you give the percent of you cpu usage and memory usage (old values and new values)?

For clearing statistics, the attached patch should work; extract and upload them to admin folder.we recommend not to clear current month raw data

Merry Christmas
Robin Paulose

January 5, 2010, 8:52 am

Private post from Arif Patmainudin

January 5, 2010, 10:01 am

Robin Paulose

Posts: 576

Re:Re:Re:Re:Re:Another issue

Hi Arif

We are not yet finished.
But I am attaching a temporary fix.
Please apply and let me know.

Also I would like to have some more data

What was the CPU usage % before upgrading to ultimate?

What is your cron run frequency? Please make sure that it does not run at a frequency greater than once every hour.

Also you might be having a graphical interface in your server which "Shows current CPU usage" (It comes under System Health)
Could you please send a snapshot of the same (before applying the patch)?

Regards
Robin Paulose

January 5, 2010, 1:41 pm

Private post from Arif Patmainudin

January 6, 2010, 9:21 am

Robin Paulose

Posts: 576

Re:Re:Re:Re:Re:Re:Re:Another issue

Hi Arif

I am attaching a patch for disabling geo targeting.
These 2 files will just exclude geo tables and geo condition from the query.
Please let me know the results
Also please send the output of "Shows current CPU usage" which I had requested in last reply.