1
Welcome, Guest. Please login or register.
November 22, 2008, 03:35:27 PM
Home Help Search Login Register
News: New Version of iJoomla Magazine for 1.5

+  iJoomla Forum
|-+  iJoomla Ad Agency
| |-+  Support Questions
| | |-+  Statistics mysql table weight		 « previous next »
Pages: [1] Print
Author Topic: Statistics mysql table weight  (Read 2284 times)
directy
customers
Newbie
*
Posts: 12


View Profile Email
« on: January 01, 2008, 07:09:49 AM »
Hi,

in this moment i have only 2 advertising zone with (more or less) 25.000 impression/day (a banner zone with 4 banner and a skyscraper zone with 1 skyscraper)

my problem is the weight of the table where the stats are stored (jos_ad_agency_stat ).

After only 1 week is now more than 18mb. (167.000 records) is there a way to reduce the type of data stored? (es. only impression and click and no other data)


 
Logged
zevs
customers
Newbie
*
Posts: 11


View Profile Email
« Reply #1 on: January 01, 2008, 10:05:11 AM »
I'd like to find out about this as well. I haven't really gone live with ad agency yet, but if its loading up on stats like that, that makes the component unusable. That needs to be fixed before nything else happens, for all of your customers' sakes.
Zev
Logged
directy
customers
Newbie
*
Posts: 12


View Profile Email
« Reply #2 on: January 05, 2008, 05:34:08 AM »
any news? the table is now 42mb!!!
Logged
zevs
customers
Newbie
*
Posts: 11


View Profile Email
« Reply #3 on: January 06, 2008, 09:02:39 AM »
On another extension that was weighing down my site with stats collection, I had a programmer comment out one or two lines in the code, and that solved the problem. IJoomla: Please reply here with instructions how to do a similar hack here.

I'm aware that Stats are an important part of ad campaign maintenance. However, if what directy says is true, (and I haven't really tested it on my site yet), I'd gladly sacrifice that for performance.

Again, assuming the problem is as bad as Directy describes, its also worth modifying this in future versions.

Thanks.
Zev
Logged
zevs
customers
Newbie
*
Posts: 11


View Profile Email
« Reply #4 on: January 06, 2008, 11:33:49 AM »
I count 15 extra mysql queries per page with ad agency. Any hacks to cut that down? The last thing my site needs is more instability...
Zev
Logged
RicardoCorai
customers
Hero Member
*
Posts: 2264


View Profile WWW
« Reply #5 on: January 07, 2008, 01:09:39 PM »
Let me ask about this, I will give you an answer soon.
Best regards,
Logged
Ricardo Corai
Moderator
www.planetacms.com
merav
customers
Sr. Member
*
Posts: 434



View Profile WWW Email
« Reply #6 on: January 09, 2008, 12:04:25 AM »
Hi guys, just saw this post. Let me ask the programmers and get back to you.
Logged
Merav
Founder
iJoomla.com
"A 100,000 website for less than a 100 bucks"
merav
customers
Sr. Member
*
Posts: 434



View Profile WWW Email
« Reply #7 on: January 09, 2008, 12:06:20 AM »
Quote from: zevs on January 06, 2008, 09:02:39 AM
On another extension that was weighing down my site with stats collection, I had a programmer comment out one or two lines in the code, and that solved the problem. IJoomla: Please reply here with instructions how to do a similar hack here.


Can you send me the name of the extension and the changes made, I will ask our programmers to take a look.
Logged
Merav
Founder
iJoomla.com
"A 100,000 website for less than a 100 bucks"
zevs
customers
Newbie
*
Posts: 11


View Profile Email
« Reply #8 on: January 09, 2008, 08:32:09 AM »
As far as I can tell, he just added one line:
   return;
Don't know what else to tell you.
Looking forward.
Zev
Logged
alin
customers
Newbie
*
Posts: 28


View Profile
« Reply #9 on: January 09, 2008, 09:27:52 AM »
Directy,
Please open a support ticket with website details so I can have a look over database.
Regards,
Alin
Logged
directy
customers
Newbie
*
Posts: 12


View Profile Email
« Reply #10 on: January 09, 2008, 02:30:39 PM »
ok, thanks. I've submitted the ticket.

as i said, is not a bug but if you need to record a line in the database for each pageview... (and i have more than 500.000 pageview/month) you have to store too much data!!! today my table is 70.6Mb!!! too much. each line is like this one:

entry_date  ip_address  user_agent  advertiser_id  campaign_id  banner_id  type 
      2007-12-22 19:21:40 1379744489 Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1;... 1 2 1 impressions

629.575 of these lines recorded in 20 days. weight 70 mb. on my server.

Better, at the moment is the system used in this component: http://www.dinoporcaro.it/

where it doesn't store a line for each impression or pageview but the total of the impressions/clicks. ok, it doesn't store others information but it saves space a lot of space...

AD Agency, in my opinion is a very good component! thanks very much!!
Marco
Logged
directy
customers
Newbie
*
Posts: 12


View Profile Email
« Reply #11 on: January 09, 2008, 02:37:13 PM »
in any case, to fix temporary the problem i tried to: select the table in phpmyadmin and choose 'Empty' to empty the table.

be carefully because you will loose all stats data stored (impressions, clicks)

bye
Logged
fsfweb
customers
Newbie
*
Posts: 1


View Profile Email
« Reply #12 on: February 06, 2008, 10:58:19 AM »
I had a file 400 megs, plus ! After a while I wasnt able to view my ads in the ads manager.

So I emptied the stats, and I was able to open the ads manager again, good thing all my banners are flat rate.
Logged
merav
customers
Sr. Member
*
Posts: 434



View Profile WWW Email
« Reply #13 on: February 06, 2008, 11:05:51 AM »
This bug was fixed on the last released, please upgrade.
Logged
Merav
Founder
iJoomla.com
"A 100,000 website for less than a 100 bucks"
Kejsaren
customers
Newbie
*
Posts: 21


View Profile Email
« Reply #14 on: April 17, 2008, 04:27:52 AM »
Quote from: directy on January 09, 2008, 02:30:39 PM

where it doesn't store a line for each impression or pageview but the total of the impressions/clicks. ok, it doesn't store others information but it saves space a lot of space...

AD Agency, in my opinion is a very good component! thanks very much!!
Marco

By "impression" and "pageview" you mean the same thing?
Logged
portugal
Pages: [1] Print 
« previous next »
Jump to:  


Login with username, password and session length

Powered by SMF 1.1.2 | SMF © 2006-2007, Simple Machines LLC
Joomla Bridge by JoomlaHacks.com 		Theme Globe by Eponnox