get a 100k objects response ?
Of course not
Check indexes
what you mean ?
Sql indexes. 30 seconds for select 100 000 rows is too large.
How exactly I can use them in my situation many to many relationship
read about the query execution plan and index optimization
you think it will help ?
The columns you use as keys must be indexed
Sure. The fact that you are using EF doesn't mean that you can't shoot yourself in a foot with poor query or unsufficient index usage. It's the database who does all the hard work after all, so...
not only keys, but all columns in "where" and it may be needed to include other columns in index too
Обсуждают сегодня