OK, so the delay you are seeing is the loading of the mapped
statements - whch i s a one time hit in the application.
I am not as familiar w/ the cs version, sorry, no optimization help here. :(
Larry
On 8/16/05, Shawn Smiley <[EMAIL PROTECTED]> wrote:
> Slight clarification on my previous message.
>
> I see the 8-10 second wait each time the NUnit test is
> run. However if I create another test with a loop in
> it, the loop executes 10 times in about 9 seconds on
> average.
>
> So I guess a better question would be how to reduce
> the initial time that it takes to get back a result
> set?
>
> Thanks.
>
>
> --- Shawn Smiley <[EMAIL PROTECTED]> wrote:
>
> > This happens consistently. I've run the test 15
> > times
> > in a row with the response time varying between 8
> > and
> > 10 seconds each time.
> >
> > My call into iBatis is from a static method that has
> > only the following two lines it it:
> > IList Results =
> > _Mapper.QueryForList("SelectVisitTeamsByVisit_New",
> > visitId);
> > return Results;
> >
> >
> > Here are the entries in my xml files.
> >
> > <resultMap id="VisitTeamUserMap"
> > class="VisitTeamUser">
> > <result property="ArtifactDirectory"
> > column="ArtifactDirectory" />
> > <result property="TeamIconCollectionName"
> > column="IconCollectionName" />
> > <result property="TeamId" column="TeamID" />
> > <result property="TeamName" column="TeamName" />
> > <result property="Version" column="Version" />
> > <result property="VisitId" column="VisitID" />
> > <result property="Active" column="UserActive" />
> > <result property="Deleted" column="Deleted" />
> > <result property="Email" column="Email" />
> > <result property="EncryptedPassword"
> > column="Password"
> > />
> > <result property="FirstName" column="FirstName" />
> > <result property="Grade" column="Grade" />
> > <result property="LastName" column="LastName" />
> > <result property="MustChangePassword"
> > column="MustChangePassword" />
> > <result property="PhoneNumber" column="PhoneNumber"
> > />
> >
> > <result property="Title" column="Title" />
> > <result property="UserId" column="UserID" />
> > <result property="Username" column="Username" />
> > <result property="DefaultPassword"
> > column="DefaultPassword" />
> > <result property="UserTeamId" column="TeamID" />
> > <result property="UsernameNumber"
> > column="UsernameNumber" />
> > <result property="UserVersion" column="UserVersion"
> > />
> > </resultMap>
> >
> > <select id="SelectVisitTeamsByVisit_New"
> > parameterClass="int" resultMap="VisitTeamUserMap">
> > SELECT T.TeamName, T.IconCollectionName, T.Active,
> > VT.TeamID, VT.VisitID,
> > VT.ArtifactDirectory, VT.Version, UA.UserID,
> > UA.OrganizationID, UA.SupervisorUserID,
> > UA.PrivacyLevel, UA.Gender, UA.UserType,
> > UA.WorkspaceStatus, UA.Username,
> > UA.Password, UA.FirstName, UA.LastName, UA.Email,
> > UA.PhoneNumber, UA.Active AS UserActive,
> > UA.MustChangePassword, UA.Title, UA.Deleted,
> > UA.Grade,
> > UA.DefaultPassword,
> > UA.UsernameNumber, UA.Version AS UserVersion
> > FROM Teams T
> > LEFT OUTER JOIN VisitTeams VT ON
> > T.TeamName=VT.TeamName AND VisitID=#value#
> > INNER JOIN UserAccounts UA ON VT.TeamID=UA.TeamID
> > ORDER BY T.TeamName
> > </select>
> >
> >
> >
> > Thanks again.
> >
> >
> >
> > --- Larry Meadors <[EMAIL PROTECTED]> wrote:
> >
> > > No, that is not at all normal.
> > >
> > > Are you seeing that consistently, or only on the
> > > first load?
> > >
> > > Larry
> > >
> > >
> > > On 8/16/05, Shawn Smiley <[EMAIL PROTECTED]>
> > > wrote:
> > > > I'm using iBatis on my first project and love
> > the
> > > > separation of the data access from my code.
> > > >
> > > > However after implementing a few pages of my
> > > > application using it, I'm noticing a significant
> > > > performance cost to using iBatis.
> > > >
> > > > For example, I have a simple query that returns
> > 48
> > > > rows of 40 fields each. The query itself
> > returns
> > > in a
> > > > fraction of a second in the SQL Query Analyzer,
> > > > however the unit test calling through iBatis
> > takes
> > > > 8-10 seconds to return the 48 objects.
> > > >
> > > > My result map does not do any selects or fancy
> > > data
> > > > conversions. The query results map directly to
> > > > properties in the data class using all primative
> > > data
> > > > types (strings, ints, bools).
> > > >
> > > > Is this performance hit normal and is there
> > > anything I
> > > > can do to improve it?
> > > >
> > > >
> > > > Thanks,
> > > > Shawn.
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > ____________________________________________________
> > > > Start your day with Yahoo! - make it your home
> > > page
> > > > http://www.yahoo.com/r/hs
> > > >
> > > >
> > >
> >
> >
> >
> >
> > ____________________________________________________
> > Start your day with Yahoo! - make it your home page
> > http://www.yahoo.com/r/hs
> >
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
