2011-05-21, 16:05
Here is what the logs say when I query with XBMC Commander. It is interesting. It looks like it does the query to get all my movies, and then 25 at a time gets movie info with another query to get all my movies in there. If this will just take a bunch of time do I have to keep the ipad on and in this app for it to finish (dont let it sleep?)
08:57:34 T:104542208 M:117919744 WARNING: JSONRPC: Type mismatch in type labels
08:57:36 T:104542208 M:117755904 DEBUG: RunQuery took 462 ms for 670 items query: select * from movieview
08:57:41 T:805003264 M:119787520 DEBUG: Thread Jobworker 805003264 terminating (autodelete)
08:58:16 T:104542208 M:103673856 DEBUG: RunQuery took 12 ms for 25 items query: select * from movieview order by idMovie desc limit 25
08:58:20 T:104542208 M:103673856 DEBUG: RunQuery took 443 ms for 670 items query: select * from movieview
08:58:59 T:104542208 M:101421056 DEBUG: RunQuery took 22 ms for 25 items query: select * from movieview order by idMovie desc limit 25
08:59:00 T:104542208 M:101662720 DEBUG: RunQuery took 442 ms for 670 items query: select * from movieview
08:59:42 T:104542208 M: 99385344 DEBUG: RunQuery took 11 ms for 25 items query: select * from movieview order by idMovie desc limit 25
08:59:45 T:104542208 M: 99385344 DEBUG: RunQuery took 454 ms for 670 items query: select * from movieview
09:00:24 T:104542208 M: 97337344 DEBUG: RunQuery took 22 ms for 25 items query: select * from movieview order by idMovie desc limit 25
09:00:25 T:104542208 M: 97341440 DEBUG: RunQuery took 486 ms for 670 items query: select * from movieview
09:01:01 T:104542208 M: 95010816 DEBUG: RunQuery took 12 ms for 25 items query: select * from movieview order by idMovie desc limit 25
09:01:04 T:104542208 M: 95014912 DEBUG: RunQuery took 401 ms for 670 items query: select * from movieview
09:01:40 T:104542208 M: 92803072 DEBUG: RunQuery took 14 ms for 25 items query: select * from movieview order by idMovie desc limit 25
09:01:42 T:104542208 M: 92803072 DEBUG: RunQuery took 412 ms for 670 items query: select * from movieview
09:02:18 T:104542208 M: 90603520 DEBUG: RunQuery took 22 ms for 25 items query: select * from movieview order by idMovie desc limit 25
09:02:20 T:104542208 M: 90603520 DEBUG: RunQuery took 465 ms for 670 items query: select * from movieview
09:02:56 T:104542208 M: 88285184 DEBUG: RunQuery took 13 ms for 25 items query: select * from movieview order by idMovie desc limit 25
09:02:59 T:104542208 M: 88526848 DEBUG: RunQuery took 410 ms for 670 items query: select * from movieview
09:03:36 T:104542208 M: 86118400 DEBUG: RunQuery took 11 ms for 25 items query: select * from movieview order by idMovie desc limit 25
09:03:40 T:104542208 M: 86118400 DEBUG: RunQuery took 443 ms for 670 items query: select * from movieview
09:04:16 T:104542208 M: 83939328 DEBUG: RunQuery took 31 ms for 25 items query: select * from movieview order by idMovie desc limit 25
09:04:19 T:104542208 M: 83939328 DEBUG: RunQuery took 408 ms for 670 items query: select * from movieview
08:57:34 T:104542208 M:117919744 WARNING: JSONRPC: Type mismatch in type labels
08:57:36 T:104542208 M:117755904 DEBUG: RunQuery took 462 ms for 670 items query: select * from movieview
08:57:41 T:805003264 M:119787520 DEBUG: Thread Jobworker 805003264 terminating (autodelete)
08:58:16 T:104542208 M:103673856 DEBUG: RunQuery took 12 ms for 25 items query: select * from movieview order by idMovie desc limit 25
08:58:20 T:104542208 M:103673856 DEBUG: RunQuery took 443 ms for 670 items query: select * from movieview
08:58:59 T:104542208 M:101421056 DEBUG: RunQuery took 22 ms for 25 items query: select * from movieview order by idMovie desc limit 25
08:59:00 T:104542208 M:101662720 DEBUG: RunQuery took 442 ms for 670 items query: select * from movieview
08:59:42 T:104542208 M: 99385344 DEBUG: RunQuery took 11 ms for 25 items query: select * from movieview order by idMovie desc limit 25
08:59:45 T:104542208 M: 99385344 DEBUG: RunQuery took 454 ms for 670 items query: select * from movieview
09:00:24 T:104542208 M: 97337344 DEBUG: RunQuery took 22 ms for 25 items query: select * from movieview order by idMovie desc limit 25
09:00:25 T:104542208 M: 97341440 DEBUG: RunQuery took 486 ms for 670 items query: select * from movieview
09:01:01 T:104542208 M: 95010816 DEBUG: RunQuery took 12 ms for 25 items query: select * from movieview order by idMovie desc limit 25
09:01:04 T:104542208 M: 95014912 DEBUG: RunQuery took 401 ms for 670 items query: select * from movieview
09:01:40 T:104542208 M: 92803072 DEBUG: RunQuery took 14 ms for 25 items query: select * from movieview order by idMovie desc limit 25
09:01:42 T:104542208 M: 92803072 DEBUG: RunQuery took 412 ms for 670 items query: select * from movieview
09:02:18 T:104542208 M: 90603520 DEBUG: RunQuery took 22 ms for 25 items query: select * from movieview order by idMovie desc limit 25
09:02:20 T:104542208 M: 90603520 DEBUG: RunQuery took 465 ms for 670 items query: select * from movieview
09:02:56 T:104542208 M: 88285184 DEBUG: RunQuery took 13 ms for 25 items query: select * from movieview order by idMovie desc limit 25
09:02:59 T:104542208 M: 88526848 DEBUG: RunQuery took 410 ms for 670 items query: select * from movieview
09:03:36 T:104542208 M: 86118400 DEBUG: RunQuery took 11 ms for 25 items query: select * from movieview order by idMovie desc limit 25
09:03:40 T:104542208 M: 86118400 DEBUG: RunQuery took 443 ms for 670 items query: select * from movieview
09:04:16 T:104542208 M: 83939328 DEBUG: RunQuery took 31 ms for 25 items query: select * from movieview order by idMovie desc limit 25
09:04:19 T:104542208 M: 83939328 DEBUG: RunQuery took 408 ms for 670 items query: select * from movieview