This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
We have been doing some testing with tables with large numbers of entries (50k) involved in complex joins to other tables.
What would be the best performing way of managing a complex multi-table join condition as processing this in memory would walk large #s of objects and Linq joining is not supported yet. In a nutshell what is the best strategy to generate a single optimized query out of the join condition which then limits the entity returned. Our current testing was finding half second first run times trying it various ways which is an order of 10 times too slow.
|
|
|
|
|
I hate to say "it depends" but... it depends. If you just want to load data from multiple tables then eager loading should do the job. If you need a cross-table projection then you will need to look at views or sprocs. If the join needs to take place in the criteria -- i.e. you are using columns from multiple tables in the WHERE clause -- then it may or may not be possible depending on the exact query. If you can provide a bit more detail or an example of what you're needing to achieve then we'd be happy to give you more precise guidance or let you know if it is beyond LightSpeed's capabilities. |
|
|
|
|
" you are using columns from multiple tables in the WHERE clause -- then it may or may not be possible depending on the exact query"
This is our case. Whats the best way to pass on the details of a test case to you?
thanks!
Gia
|
|
|
|
|
If a small code fragment will show what you're trying to achieve, just post it here. It sounds like posting the query expression or LINQ query should be enough for us to get the idea (and we can always follow up if we need more info). If the scenario is more complex, a small console project is ideal. You can attach a zip file via the Options tab. If the query or model contains confidential information, and it's not practical to create an "anonymised" repro, you can e-mail us via the Contact form, or mail me directly on ivan @ the obvious domain name. Please remove any binaries first. |
|
|
|
