2011-11-08, 23:15
odt_x Wrote:Hi!
Heres a sample of running the 0.0.4 version of the script and how long it takes for me.
http://pastebin.com/1dWXyWH7
right, it's the json query that takes up most of the time.
the time it takes to get a response is approx 7 secs at your end:
Quote:22:20:47 T:208 DEBUG: script.watchlist: ### json query
22:20:54 T:208 DEBUG: script.watchlist: ### load response
the processing of the response in the script takes practically no time:
Quote:22:20:54 T:208 DEBUG: script.watchlist: ### load response
22:20:54 T:208 DEBUG: script.watchlist: ### iterate results
22:20:54 T:208 DEBUG: script.watchlist: ### sort list
22:20:54 T:208 DEBUG: script.watchlist: movie list: 74 items
so i doubt there's anything the script can do to speed things up.
things may be faster when using sqlite, but i'm not sure...
or perhaps your sql server is running on a slow/old machine
or maybe it's just the way things are :-)