Re: Delphi 6 - ADO - MS SQL Server


Well I was talking in relative terms rather than absolute milliseconds. The
time taken was about 150ms per record to do the edit/post. It doesn't sound
a lot, but we're expected to process about 700k records and it all adds up,
of course (29 hours to do the lot). I was just expecting it to halve the
amount of time taken when I used Stored Procs and was rather taken aback
when it didn't.

Using the TadoConnectoin.Execute method is the lowest overhead way to execute
and SQL statement
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • Re: Delphi 6 - ADO - MS SQL Server
    ... Well I was talking in relative terms rather than absolute milliseconds. ... time taken was about 150ms per record to do the edit/post. ... It doesn't sound ... I was just expecting it to halve the ...
    (borland.public.delphi.database.ado)
  • Well, THAT was impressive!
    ... ATK-Thiokol had a static test firing of a Shuttle RSRM yesterday. ... as impressive as the sight and sound of the thing live and in person. ... The universe fills up with the sound of the rocket. ... and had not been expecting. ...
    (sci.space.history)
  • Re: 5 spiritual ingredients was Re: Burning Times
    ... > I didn't ask to see this shit, y'know, I was expecting 'The Sound Of ...
    (uk.religion.pagan)
  • Re: JULIE HARRIS
    ... Foote, I think, is that you go in expecting a "southern writer" and he ... doesn't really sound like that ...
    (rec.arts.theatre.musicals)
  • Re: Damn! :(
    ... an 8.7 which I wasn't really expecting after an ill-chosen meal (well ... sound like the *miseries* have truly set in at your house. ... How may strawberries did you have? ... Good luck on dealing with that infection... ...
    (alt.support.diabetes)