Re: executeBatch()
From: Steffen Ramlow (s.ramlow_at_gmx.net)
Date: 06/14/04
- Previous message: Joe Weinstein: "Re: executeBatch()"
- In reply to: Joe Weinstein: "Re: executeBatch()"
- Next in thread: Joe Weinstein: "Re: executeBatch()"
- Reply: Joe Weinstein: "Re: executeBatch()"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 14 Jun 2004 22:21:28 +0200
Joe Weinstein wrote:
> Good test, but were you able to determine whether the oracle driver
> sent the real batch execute in one packet,
Yes, (IIRC) I could see it in the oracle trace I made.
> It might be that the MS driver/DBMS was also extremely fast is
> it sent all the sp_execute calls at once too,
No SQL Server Profiler says one call per statement.
> and this also seems to
> show a weakness in the oracle sql parser...
It seems that these guys think, everybody uses bind variables :)
> Well, the MS driver comes from a company that makes drivers for
> several DBMSes,
> so there is probably a considerable amount of generic code and
> algoritms that
> is being used in the MS driver.
Should I test merants oracle driver too!? :)
But what I did, I have tested i-net's seropto, it took 2,8 s instead of the
0,1 s with the oracle driver.
-- Kein Plan überlebt die erste Feindberührung.
- Previous message: Joe Weinstein: "Re: executeBatch()"
- In reply to: Joe Weinstein: "Re: executeBatch()"
- Next in thread: Joe Weinstein: "Re: executeBatch()"
- Reply: Joe Weinstein: "Re: executeBatch()"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
