[Solved] Performence Problems

[Nils]

Hi,

we have some Performance Problems with huge Data-Sets. 
We use a simple (not complex) Class (Named: Location) with about 10 Properties.
If we load about 50 Location-Objects it takes 3 Seconds to load this.
If we load about 350 Location-Objects it takes 10 Seconds to load this.
If we load about 2000 Location-Objects it takes 50 Seconds to load this.

The Database has about 50000 Locations and other Tables

So i want to ask:
Can we improve something or is the context not intended for to load large amounts of data?

For loading we use this Code:
this.context.GetAll<Location>().Where( [some filter expression] )

Thanks,
Nils

[Bulent]

Hello Nils,

Thank you for using our persistence solution.

The performance issues that you describe look like a result of some non optimized queries. 
My suggestion for you is to read the following blog article . It will give you idea where to start optimizing your data requests. If you still encounter performace issues after applying them I would ask you for database file with example of the slowest queries that you use in your application.

Please, let me know if this information is helpful.

Regards,
Bulent
Telerik

 

 

[Nils]

Thanks for your fast answer.

I read this blog before i have write this thread. I've add some indices and nothing changed.

I had tried to load the whole Table it takes more than 5 minutes so i canceled the debug-instance.

I don't think that indices can change something, because if i do "this.context.Get<Location>().Count();" it takes less than 1 second. 
Only if i want to get the Location-Objects with the Data-Storage.

Have you something other ideas?

Regards,
Nils

[Bulent]

Hi Nils,

Thank you for your quick response. 
It looks like this issue should be profiled in depth. In order to reproduce and investigate it I need a solution with problematic queries and database file that is populated with data. Can you prepare and send to me such kind of simple project?

Regards,
Bulent
Telerik