asked on January 2, 2019
Hi,
When I generate a report I get a widget which says " Loading Data xxxxx K". What does the K stand for? Is it KB or something else? Could you please clarify?
Regards,
Majar
⋅ January 2, 2019
Hello, Majar,
Thank you for writing!
The K on the "Load data" widget stands for KB.
In case you would want to replace the 'K' with your custom text, check out the Localizing component tutorial. Localization can be used to change this label.
Please let me know if you have any other questions.
Regards,
Tanya
⋅ January 3, 2019
Thanks Tanya, But for a report it is showing around 2,000,000K. But the response size is only around 400 KB. Could you please clarify how the size in the widget is being calculated?
Please note we are generating report using csv compressor
Regards,
Majar
⋅ January 3, 2019
Hello Majar,
Thank you for the details.
We have checked CSV compressor and it seems that there is an issue with KB formatting (value should be divided by 1024).
The fix will be available in the next minor release (ETA Jan 28).
Still, it's not clear why it can be 2000 KB instead of 400 KB.
Could you please provide us with your CSV sample file and specify the Data Compressor technology (PHP, Java, .NET)?
Look forward to hearing from you.
Regards,
Ian
⋅ January 3, 2019
Hi Ian,
Thanks for the support. We are using .Net.
I'm sorry because I wrongly mentioned that .csv implementation link, but we are using relational database(https://www.flexmonster.com/doc/connecting-to-relational-database-with-net/).
The report(response size 1.0MB) is taking more than 30 seconds (after the 'loading for the response' changes to 'xxxxxxK 'in widget) to generate. After checking the response I could find that it is the content download time. But I think it is too long because the size is just 1 MB. Why is it?
Regards,
Majar
⋅ January 4, 2019
Hello, Majar,
Thank you for a quick update and specifying the additional details.
Please have a look at our best practices for performance optimization:
Following these practices should decrease data loading time.
Please let us know if applying the best practices helps.
Regards,
Tanya
⋅ January 7, 2019
Hi Tanya,
Thanks, We will try to configure GZIP compression. But I don't think It should not take >30 s to download content of 1 MB .
Regarding streaming response:- We are currently using streaming approach to return data from the server as mentioned in the documentation. While debugging I found out that writing to response.Content is taking time(>30s,which is the download time of response). The report will be loaded only after the writing(to response.Content) operation completes. I'm not sure it is the expected behavior.
Thanks,
Majar
⋅ January 7, 2019
Hi Tanya,
I implemented GZip Compression, The response size and the content download time are reduced, but the Waiting(TTFB) time is increased as GZip compression waits for the response.Content to be written. The time to generate the report is same.
Regards,
Majar
⋅ January 9, 2019
Hello Majar K,
Thank you for your feedback.
We are not able to reproduce the same behavior where the response takes too much time.
Could you please provide us with the sample project for reproducing the issue? We would need a database sample and a code example which generates the response. Also could you please specify what version of the component and compressor you are using?
That information will help us a lot in our further investigation.
Regards,
Dmytro
⋅ January 29, 2019
Hello Majar K,
We are glad to inform you that the latest version of the component includes the fix for KB formatting.
You are welcome to update the component and try it.
Regards,
Dmytro
