[wp-hackers] Network activations and WP SlimStat

[Vid Luther]

Just adding my $0.02.

Dino Termini wrote:
>
>> You have a point here, however I think you're thinking of an edge
>> case. 1 million records of hits is too much to be storing in the first
>> place.
>
> Okay, maybe that was a little exaggerated, but even with 100,000 
> records, what's the difference bw 100 tables holding 100k records and 
> one storing 10M? It 'scales' just because it doesn't create new 
> tables, but other than that it's the same thing space-wise. Unless you 
> core developers are saying that adding new tables is deprecated and 
> should never be done.
>
on heavily trafficked websites.. the # of open files, disk i/o, 
replication, etc is all affected.


>>
>>> that it's better to load a 3.5 Mb array into memory EVERY TIME the 
>>> plugin
>>> has to record a new hit, than querying the database to find the same
>>> information, am I right?
>> No, I'm saying that you don't need to record the country at all in the
>> first place. You need to know the country at display time, not at raw
>> data grabbing time. Raw data should be *raw*. Fast. Efficient for
>> writing. Save the processing for later.
>>
>
> So you would do a JOIN bw two tables, one with 100k records and one 
> with 150k, for EACH metric included in WP? Interesting...
>

The number of times you'll need to actually see the country is far less 
than the number of times you're currently looking it up. I agree with 
Otto, when it comes to statistics,
and especially these types of stats, store the info as quickly as 
possible, writing to mysql will always be your slowest, and longest 
operation. Every insert usually requires an
update to the index.

>>
>> Nobody wants the raw data except for eggheads like you and me
>
> Well, I would ask that to the 2,000+ users who are currently using my 
> plugin :-) Maybe it's not just you and me...
>

Using it versus how they're using it :). 
http://www.romymisra.com/the-google-analytics-user/

I say all of these not as an expert on WordPress core, but as someone 
who worked on an analytics package that handled millions of visits per 
hour.



> Dino.
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers