Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

[b]Hibernate version:nhibernate-1.0.2.0[/b]

[b]Mapping documents:[/b]

[b]Code between sessionFactory.openSession() and session.close():[/b]

[b]Full stack trace of any exception that occurs:[/b]

[b]Name and version of the database you are using:SQL Server 2000[/b]

[b]The generated SQL (show_sql=true):[/b]

[b]Debug level Hibernate log excerpt:[/b]


Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html

I have one DB in sql server 2000; named 'PowerDB'; and one program in C#.Net 2005 named 'Power.CS'.
I use nhibernate-1.0.2.0 to connect to 'PowerDB'. I have requierd classes and map files and also so many querys in HQL, to insert data into DB, to read data from DB and to update and delete data.
When I run Power.exe on my server every thing is ok and i get response in an acceptable speed.
Here we have a local network; when I run Power.exe from a remote computer response time increases, efficency decreases.
I set connection and query time to zero (means unlimited).
Do you know where the problem is? What should I do to get a response as fast as possible?[/url][/list]