2012-02-05, 01:20
GJones Wrote:MySQL is not the bottleneck here. The processing of the tv shows is sequential. It calls the database for each tv show separately. The setup and processing of the json for each call take the great majority of the time in the script running.
The only way to improve the speed is to require less database calls (like pulling all the episodes once and then just sorting/filtering in python) or to use a specific query to focus on retrieving very specific information from the database.
How can I do this?