Oh and BTW, are you returning any large columns in your query?
On 12 Mar., 15:05, TigerShark <[email protected]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
