It seems that somebody mentioned this to me in the past, perhaps BillD, but I've just been evaluating some poorly executing code, i.e. it executed TOO SLOW, and, lo' and behold, I've snookered myself.
I've been doing a particular UPDATE like this : UPDATE + MY_TABLE + SET + CurrentCT = (.vCurrentCT), + JobComplete = (1) + WHERE + ID = (.vID) + AND + TimePeriod = (.vTimePeriod) + AND + vProjectID = (.vProjectID) The table is stored in a shared database on a server and has 13 columns with 40K records. For this testing I am the only user, but there are normally at least 3 users performing the same type of operations and executing this statement concurrently. In this testing, the UPDATE (FEEDBACK ON) takes between 1.2 and 2.6 seconds (I can't explain the variation except that it takes longer the first time after connecting to the database then if I've already executed the statement ; buffers, caches?), which is really too long. However, when I remove the paren's and execute, FEEDBACK shows "instantaneous" results and I believe it, as that's what I'm perceiving, i.e. 0-wait response-time. I noticed, too, that the paren's around the constant in the line, JobComplete = (1) seem to have no impact, whether they are there or not. However, the paren's around the dotted variables DEFINITELY make a difference. It seems that I recall being told that paren's look to the parser like FUNCTIONS, so it looks for the code belonging to the function in order to execute it. In this case there is no code, as it's not a function. Anyway, could someone fill me in on all this? Thanks, Steve in Memphis --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [EMAIL PROTECTED] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
