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
|
I believe some ORM, like for instance NHibernate, allow SQL queries to be manipulated manually in order to be able to fine tune performance. I have not found that this is a possible option with LightSpeed. Is that something that that you support or plan to support? Or do you reckon you always make the most optimal SQL query for the situation? ;~) As I side comment, I don't consider this a show stopper for us. If we would find that need, we probably would side step the ORM making a traditional query for the special scenario in this case.
|
|
|
Hi Tobias, LightSpeed, in general, produces relatively simple queries that require little optimization. The framework's primary optimization technique is to provide you with complete control of how much data is retrieved per call. This "eager loading" is perhaps the most advanced of all the ORMs on the market (one of only two able to pass the Mats Challenge - a data load efficiency test created by Mats Helander). Additionally, LightSpeed has a very powerful batching engine which can group together SQL statements to reduce the number of database round trips. For generating custom queries, LightSpeed also exposes the underlying Connection and Command factory which allow you to run custom SQL whilst still leveraging LightSpeeds optimized connection handling model. Cheers, Andrew. |
|
|
sounds great! thanks. |
|