Hibernate version: 1.2.0.4000
Name and version of the database you are using: SqlCE v3.5 beta2
i am using nhibernate 1.2.0 with sqlce v3.5 in c# .net 2005.
my db scheme is a school where a student have a section and a level object.
i have about 480 record in it. i can read these records with Sql Server 2000 in 3 seconds, but in SqlCe 3.5 it takes about 45 sec to load all relations.
i found out that loading just objects without any of their relations does not take longer than 1 second. but with every single relation to an object the time is increasing heavily...
is there any setting or any trick that i forgot to do ?!
and lastly about SqlCE v3.5 beta2 , i previously worked with sqlCE v3.1 but it have same speed problem .
|