Again, Peter, I think you have hit on something here. Good detective work. So 
it was not the SQL queries that were causing the delay? Good to know. I think 
it is a bug of some kind, but then I am the Bugmeister, so that is expected. 

I would submit a bug and see where it goes. 

Bob


On Nov 11, 2010, at 10:03 AM, Peter Haworth wrote:

> I think I have found  the cause of the performance problems I have been 
> experiencing.  I had been referring to objects by their long name in various 
> places in the offending code.  I started changing the code to refer to the 
> same objects by their short ID and each line of code I changed resulted in 
> quicker performance.  I haven't been able to change all the code yet but the 
> evidence is that the performance issues will go away when I start using the 
> object IDs everywhere.
> 
> Finding the problem is good of course but does anyone know why there are no 
> performance issues referring to an object by it's long name in the IDE but it 
> causes such a performance hit in a standalone?  Maybe I'm misunderstanding 
> the process of building a standalone but I would have thought a standalone 
> would function more efficiently than the same code executed in the IDE not 
> less, kinda like in the old days of interpretive vs compiled BASIC?
> 
> Pete Haworth
> 
> 
> 
> 
> 
> 
> 
> 
> _______________________________________________
> use-revolution mailing list
> use-revolution@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution

_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Reply via email to