Re: Perofrmance problem Ibatis 1.2/.NET 2.0/SQL SERVER 2000

[Prosper]

Hello evrybody;

some more precision about my perf pb:

 

I did some benchmarks in order to understand where does ibatis spend its time:

 

Bench 1: a simple select, 10 loops, using in one case Ibatis 1.2/mssql2000, ansd in the other case ADO/MSSQL2000; the MSSQL Profiler shows that Ibatis made more than 75000 reads on the server for a duration more than 2000, while ADO made just 3 reads for a duration of 0.

 

Bench 2: same test, but with MSSQL2005: at this time the two did 3 reads on the server for a duration of 0ms.

 

Does anyone could know why Ibtais makes so much request to the server on the case of mssql2000?

 

Regards


Prosper <[EMAIL PROTECTED]> wrote:

Hello every body,

 

I deal with performance problem using batis with .NET2.0 over sql server 2000.

 

- over sql server 2005, i have responses times of 2 ms; with the same configuration but over sql server 2000, the response time jumps to 3000ms; and when using ADO.NET over sql server 2000, response time is less than 75ms.

 

Does any one has encountered this performance issue of Ibatis with .NET 2.0 over sql server 2000?

 

Regards.

---

Everyone is raving about the all-new Yahoo! Mail.

---

Everyone is raving about the all-new Yahoo! Mail beta.