ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Priyesh Mashelkar" <priye...@mastek.com>
Subject RE: Executing a Stored Procedure returning rows from a Temporary table
Date Mon, 08 Aug 2005 15:22:00 GMT
Sorry if I forgot to mention,  the multiple clients would be concurrently executing. And the
problem starts here.
And according to the performance measurements we have been carrying out,  even a single db
interaction counts a lot when performance is one of the deliverables.

-----Original Message-----
From: Koka [mailto:226057@gmail.com]
Sent: Monday, August 08, 2005 8:39 PM
To: user-java@ibatis.apache.org
Subject: Re: Executing a Stored Procedure returning rows from a
Temporary table


> multiple clients may call this Stored Procedure and we would have to somehow separate
the outputs for the various clients

Hmm, never used SQL server, but in oracle TEMPORARY table carries
session-specific or transaction-specific data. If situation is
different for the SQL server you'll have just to rollback after
running select (i.e. procedure: delete rows, fill in required rows;
select rows, rollback). So not much to do there,

And also, IMHO, extra trip to database will be ever noticable compared
to time you need to fill in rows and retrieve them

Good luck
Koka



MASTEK
"Making a valuable difference"
Mastek in NASSCOM's 'India Top 20' Software Service Exporters List.
In the US, we're called MAJESCO

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Opinions expressed in this e-mail are those of the individual and not that of Mastek Limited,
unless specifically indicated to that effect. Mastek Limited does not accept any responsibility
or liability for it. This e-mail and attachments (if any) transmitted with it are confidential
and/or privileged and solely for the use of the intended person or entity to which it is addressed.
Any review, re-transmission, dissemination or other use of or taking of any action in reliance
upon this information by persons or entities other than the intended recipient is prohibited.
This e-mail and its attachments have been scanned for the presence of computer viruses. It
is the responsibility of the recipient to run the virus check on e-mails and attachments before
opening them. If you have received this e-mail in error, kindly delete this e-mail from all
computers.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


Mime
View raw message