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
-~----------~----~----~----~------~----~------~--~---
