search

Jeak / ggLog

Online Running Log
http://ko.kooia.info/ggLog/
2 stars 1 forks source link

Can't deal with a lot of entries. #13

Closed davidberard98 closed 9 years ago

davidberard98 commented 9 years ago

A significant issue: I tried adding 2000 random entries. Although server-side MYSQL command to "select *" supposedly took .06 seconds (it took multiple seconds to send all the info through ssh), there was apparently a problem in weeks.php which caused over 30 seconds of thinking. Need to make it more efficient: the MYSQL isn't having issues, but probably the sorting php has some issues. In fact, why do we even use weeks?

davidberard98 commented 9 years ago

It's from displayWeeklyDistances().

davidberard98 commented 9 years ago

Seems to be line 261 of weeks.php. Need to find a better way to sort. Perhaps python or even c++ script to do the calculations?

davidberard98 commented 9 years ago

c++ still an option, but it is an acceptable speed right now: less than 2 seconds for each section (weekly mileages, recent workouts) with 2000 entries. Probably would be good to optimize further, since 4 second processing is kind of a lot.. But fine for now.