HP3000-L Archives

December 1997, Week 1

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Joe Geiser <[log in to unmask]>
Reply To:
Joe Geiser <[log in to unmask]>
Date:
Fri, 5 Dec 1997 22:26:16 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (17 lines)
Jim brought this issue up due to a conversation we were having, based on the
recent 3000-L thread.  There is a portion of an application (a client-server
application) which must update a sort item.  I've been debating the use of
CIUPDATE to gain the efficiencies (this is running over a 56K line from
Texas to Ohio)) of an UPDATE action query, or doing DELETEs and INSERTs -
which I know will maintain the sort order of the sort key.

Since there are legacy apps rely on the sort item - I can get around this by
resorting the recordset (with ORDER BY) when doing inserts - but I'd rather
use and UPDATE action query.

So - we'll put this one to bed - I have both pieces of code written - I will
test both and let you all know.  I also want to test this in Texas though,
over that 56K Line - it's a big difference over a 10/100 LAN here.

Joe

ATOM RSS1 RSS2