Site
Home / Forum / Developers / League Table Api
Home / Forum / Developers / League Table Api
League Table Api |
| Posted: 25 Sep 2020 08:21 | |||
 Posts: 346 Joined: 2020 | Hi Zag, Not sure if this is the right place to report this but the football league tables API is currently really slow to get data. i.e. a request to https://www.thesportsdb.com/api/v1/json//lookuptable.php?l=4329&s=2020-2021 takes approx 9 seconds to complete but only returns 3kb of data. In comparison, the events by day api takes 63ms and returns 20kb of data. Cheers | ||
 | |||
| Posted: 26 Sep 2020 21:42 | |||
 zag Posts: 3,619 Joined: 2020 | Thanks yeh theres a lot of backend work going on like the timeline stuff which will effect it but also longer term make it quicker. I will check the indexes as it should be that slow! cydalby | ||
| |||
| Posted: 27 Sep 2020 14:21 | |||
 Posts: 36 Joined: 2020 | i have actually reported that in one of the comments or posts , but i got no response , i basically get the response after almost 5 - 6 seconds | ||
| |||
| Posted: 19 Oct 2020 12:39 | |||
zag Posts: 3,619 Joined: 2020 | Just been having a look at this but I cant see any performance issues on first glance. I'll need to look into this deeper I think. | ||
| |||
| Posted: 19 Oct 2020 17:49 | |||
Posts: 346 Joined: 2020 | Is it taking as long for you? | ||
| |||
| Posted: 19 Oct 2020 18:09 | |||
zag Posts: 3,619 Joined: 2020 | Yep same 6seconds for me, can't work it out as the code is pretty much identical to the table on the website which is instant. I'll have a play around with the database indexes. Its been a while since I profiled the MYSQL commands. EDIT: Ahh seems to be a big issue on the premier league and other leagues seem quicker. Interesting... https://www.thesportsdb.com/table.php?l=4328&s=2020-2021 https://www.thesportsdb.com/table.php?l=4335&s=2020-2021 | ||
| |||
| Posted: 23 Oct 2020 10:59 | |||
zag Posts: 3,619 Joined: 2020 | I think this is just bad logic in my part, I will look to improve. | ||
|
Who is Online? In total there are 68 users online :: 3 registered, 0 hidden and 65 guests (based on users active over the past 5 minutes) Most users ever online was 424 on Fri Nov 10, 2017 9:02 pm | About Us Discussion forum for TheSportsDB.com site and related topics | Rules - Be Polite - Respect other users - Always post log files with issues - Try to be helpful - No Piracy discussion |