I have integrated zenith with my qlik analytics to built reports using the data stored in zenith. There is a issue with the query that in rest connection first it runs the select query and gradually the response and other sub tables. In my case the select query is taking to long to load and getting failed after 2 hrs. What steps should I take because any type of LOAD can be applied after select query and I am facing issue with the select query only. Please suggest other methods that would be helpful. I am attaching the query it doesn't have data more than 0.3-0.4 million. SELECT "last_id", "has_more", "total_this_page", "next_page_url", "__KEY_root", (SELECT "id", "call_date", "username", "location", "phone_number", "disposition_code", "status_name", "lead_id", "recording_id", "filename", "campaign_id", "campaign_name", "call_type", "__FK_response" FROM "response" FK "__FK_response"), (SELECT "__FK_applied_filters" FROM "applied_filters" FK "__FK_applied_filters") FROM JSON (wrap on) "root" PK "__KEY_root";
Is it possible that the reason for the query being slow is that it's lots of data, so that it simply takes a lot of time? Perhaps you could alter the api query so that fewer rows are being returned? Maybe you don't need to fetch all pages all the time? Or maybe you can filter the query on call_date so you only fetch the latest ones? In that case you could fetch for example one month at a time, and store the fetched data into QVD files. When you eventually have all the historic data you need in qvd files, you only need to get new data when querying the api.
