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
|
The following is stated under compiled queries documentation pertaining to compiled query parameters: http://www.mindscapehq.com/documentation/lightspeed/Advanced-Querying-Techniques/Compiled-Queries (Note: anonymous types, though convenient, are relatively slow. Depending on the performance characteristics of your query, it may be worth using an optimised implementation of ICompiledParameterValues based on a switch statement or a dictionary. I'm not sure I understand
|
|
|
|
|
Its less performant because we need to use reflection to get the key/value pairings as opposed to a specifically crafted ICompiledParameterValues implementation which knows how to match up a key to a property value bypassing the reflection cost. For best performance implementing specific ICompiledParameterValues implementations is the way to go but the difference on a limited number of calls is going to be pretty marginal.
|
|
|
|
