Loading data and splash screen time

BitSmithy 2,041

Hello,

I am loading data to the app using such code now:

private async void Page_Loaded(object sender, RoutedEventArgs e)         
{ 
	await CreateDataBaseIfNotExists(); //creates database if it doesn't already exists.
	await LoadData(); //loads data to DataGrid
}

But this method causes that Splash Screen is showed to long.

I would like to load data after the app is loaded or (better) start loading during splash screen time and finish it after splash screen is hidden.

Is that possible in uwp?

Junjie Zhu - MSFT 17,636 Reputation points Microsoft Vendor

2024-09-18T09:50:57.5566667+00:00

Hi @BitSmithy ,

Are you reading the database in LoadData()? If so, I suggest you read the first 50 rows in the table first, and then read after the DataGrid is loaded.

Could you please describe what you do in LoadData()? Maybe you can optimize the code.

Thank you.
BitSmithy 2,041 Reputation points

2024-09-20T10:38:57.91+00:00

Are you reading the database in LoadData()?

Yes, I load data from SQLite in LoadData method.

I suggest you read the first 50 rows in the table first, and then read after the DataGrid is loaded.

It looks promising - Does I must attach handler to DataGrid.Loaded method during StckPanel time and next after DataGrid is loaded I must take off handler from DataGrid.Loaded event, clear datagrid data and in the end, load data again?

Could you please describe what you do in LoadData()? Maybe you can optimize the code.

I cant count that I will optymize database loading becouse I dont know how big it will be and dont know how will be the device performance. I need the solution where database will be loaded in most time after SplashScreen time.
Junjie Zhu - MSFT 17,636 Reputation points Microsoft Vendor

2024-09-23T08:19:04.9733333+00:00

Does I must attach handler to DataGrid.Loaded method during StckPanel time and next after DataGrid is loaded I must take off handler from DataGrid.Loaded event, clear datagrid data and in the end, load data again?

You can try to use data binding to do this, read only the first 200 rows at the beginning, and then read the rest in the loaded event. You can use OFFSET FETCH in SQL to query.

No need to delete events or update data, data binding will do it for you.

1 answer

Junjie Zhu - MSFT 17,636 Reputation points Microsoft Vendor

2024-09-27T08:08:09.12+00:00

Hi @BitSmithy ,

Let me summarize this question.

I would like to load data after the app is loaded or (better) start loading during splash screen time and finish it after splash screen is hidden. Is that possible in uwp?

You can try to use data binding to do this, read only the first 200 rows at the beginning, and then read the rest in the loaded event. You can use OFFSET FETCH in SQL to query.

No need to delete events or update data, data binding will do it for you.

Thank you.

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Loading data and splash screen time

1 answer

Your answer