Hi, Thanks for your replies, and sorry to response so late. I finally found the reason. My connection string is fine,the configuration for nhibernate is also fine,. I then went and checked the table i did select against... Oh my,No primary key!!Our DB admin recovered that table(Note:this's a test table) without notice me...the primary key lost after that recovery.
I reset the Id column as the primary key,then re-run my unit tests,NH rocks like a charm. On Mar 13, 12:47 am, Jay Chapman <[email protected]> wrote: > That's right, sorry I had it backwards. Thanks. > > On Thu, Mar 12, 2009 at 12:19 PM, James Gregory > <[email protected]>wrote: > > > I believe Get always goes to the database, Load returns a proxy. > > > On Thu, Mar 12, 2009 at 4:15 PM, Jay Chapman <[email protected]> wrote: > > >> How do you know the select statement that NHibernate used? Were you using > >> a profiler? Did you log NHibernate's sql. NHibernate doesn't do anything > >> special that would cause the query itself to be slow. If you're getting a > >> timeout it's a sql timeout. I'm guessing the actual query is different, > >> and > >> is probably trying to load other related objects where maybe something is > >> misconfigured. > >> If you're using the default configuration (proxy) for objects, I do not > >> even think that method you say you called will go to the database. It'll > >> just return a proxy. Has that changed in a recent version? > > >> On Thu, Mar 12, 2009 at 4:26 AM, Levin <[email protected]> wrote: > > >>> Hi, > >>> I'm a newbie to NHibernate,today i try to fetch a record from a > >>> large table using NHibernate. > >>> My table has a primary key of string type,and currently has more > >>> than 1000000 records. > > >>> I tryed: > >>> session.Get<PackingSlip>("xxx"); > > >>> NH executed the sql "Select .... from PackingSlips where id='xxx' > >>> against my db,but it's very very slow,always complained 'timeout'. > > >>> If i execute the same sql directly on the ms sql management > >>> studio,it's done immediately(maybe less than 0.1 second). > > >>> Can somebody tell me why?Thanks so much! > > >>> BTW:My NH version is 2.1GA --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
