Reply To: FireStats – Top 40 php script (now with added charts)

#14782
sonichouse
Participant

@Iris wrote:

Okay, Steve

Once I added set_time_limit(60); and was able to “Refresh Charts” without it crashing my times dropped to <5 secs with the exception of "Added" 35.825750 seconds and "Played" 16.197334 seconds. I don't know if that's something that can be improved upon. I've always had the impression that the MSS in general had better response times than the Slug but maybe not.

The error on the summary page still exists though!

Before, I try 1.20 does this added info help or should I install 1.20

Iris

I wonder if we need to add an index on play_count .

create index idx_played on songs(id, play_count);

Go with 1.20