1) Correct. Proxying enables lazy loading. 2) SQL can be more performant for really complicated queries, but I wouldn't worry about it until you know there is an issue. Go with HQL or Criteria unless your query does something that would obviously be better suited to plain SQL. Have a look at querying with native sql<http://www.nhforge.org/doc/nh/en/index.html#manipulatingdata-nativesql>in the docs for more info on it.
On Tue, Apr 7, 2009 at 9:13 AM, Arman <[email protected]> wrote: > > hi , > > as i am working with nhibernate for more than 2 year , but i have 2 > simple questions yet, > > 1- what a proxy is ? what i think is that a proxy is something like > watcher that when i want to access that object the proxy understand > and fetch that object from database at that time, it maybe useful for > performance in loading relations or objects . but i dont know if i'm > correct or not > > > 2- as you know in some reports , we want to get a complicated and > complex and heavy query , my question is , which one is better in > these situations? HQL or native SQL ? > if your answer is SQL , can i write my query in hql and get it's sql > translate and then run sql for get more quick results ?? > > thank U All, > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
