are you sure you're using the correct connection string for your nhibernate configuration?
when you run your code which uses nhibernate, can you use sql server's profiler to see if you actually connect to the database? On Thu, Mar 12, 2009 at 9: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 -~----------~----~----~----~------~----~------~--~---
