Seems like there's something wrong with your configuration. What happens if you execute the same statement using plain ADO.NET code?
On 12 Mar., 09:26, 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 -~----------~----~----~----~------~----~------~--~---
