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.

I'll have a go at your method, which seems intriguing and very lateral.

Cheers

"Steve Zimmelman" <skz@xxxxxxxxxxxxxxxxxx> wrote in message
news:45129039$1@xxxxxxxxxxxxxxxxxxxxxxxxx
How much time to post are you talking about? I have a client who has a 40
gig
DB, 100+ users, using SQL Server and ADO, with no performance issues.

Every table has a primary. We use TAdoQuery for reading and some posting,
and
some stored procedures for updating. I stopped using the TADOStoredProc
and use
mostly dynmaic SQL to address the SP's.

For example, your SP could be executed:

ADOCommand1.CommandText :=
'dpersUpdateIndividual '+
InToStr(ID)+','+
QuotedStr(Title)+','+
QuotedStr(Surname)+','+
QuotedStr(FirstName)+','+
QuotedStr(MiddleName) ;

ADOCommand1.Execute ;

-Steve-


.

Relevant Pages

  • Re: Delphi 6 - ADO - MS SQL Server
    ... time taken was about 150ms per record to do the edit/post. ... It doesn't sound ... I was just expecting it to halve the ... Brian Bushay (TeamB) ...
    (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)