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....
Karen In a message dated 9/14/2011 9:22:42 AM Central Daylight Time, [email protected] writes: > If I run temp.prg from the R> prompt, it executes in .2 seconds (two > tenths of a second). > > > If I do RUN temp.prg from inside a form, the same code takes 3.6 seconds, > almost 20 times as long, to execute. > > > I am not changing any variable values in my code that might affect lookups > on the form. The form is a variable form. > > > Does anyone know what could be causing the difference, and how I can work > around it? > -- > Larry > >
