Larry, just for a test, try putting your code in a Stored Procedure and
CALLing it from the form. It might be faster, and I might be out to
lunch - it's happened before.
Albert
On 14/09/2011 8:39 AM, Lawrence Lustig wrote:
<<
Larry: Aside from my question about the version, when you run it from
the r> prompt, is it possible the query is so fast because you have
done the query before and the answer is already in cache? One test
is to exit RBase, come back in, define your variables and test again.
If it truly is that fast the first time you do it, then I have no
answer for you....
>>
V 7.6.
I've run each version several times in succession and the results (0.2
seconds vs 3.6 seconds) are very consistent.
--
Larry
--- 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.
================================================
