As the title suggests, I am using an SQLite datasource (local) for my application data. Every data grid that loads this datasource takes an abnormally long time to load (5-30 seconds) than what I am used to having come from SQL server. Is there a specific reason for this? And is there any way I can improve speed while still using SQLite? the datasource data types are integer and text only.
Thanks!
Hi @Andrew_Paull,
How many records are displayed in the DataGrid? Is the paging enabled?
Hi @enchev , there are very few records in my tables. Less than 25 in any of them. Paging is not enabled because of some custom rendering I have of which paging breaks the design.
Unfortunately Iām not sure what can cause it in this case.
Maybe this is related.
I would be inclined to agree with you, but I only have custom rendering on one page. All datagrids on all pages are loading slow.
I do not have a 'text' limit set in my database. even though the values are small, could an SQLite database with no table limits cause a problem?
You will need to debug your pages to see where the slowness is coming from. Is it data access, rendering, etc.
So, I'm noticing Radzen is not producing a any console info after loading my web assembly, and visual studio is not giving me any valuable data to determine the issue. What is an appropriate method to debug that might help me drill down on this issue specifically. I have no errors or exceptions.