Ye Gods - I'm a SQL programmer - It's a miracle !!
No, it's OK - I've just thrown cold water on my face and woken up - I'm only human after all
In reality, I suppose that I am looking for guidance on what is a 'low overhead' process and what is 'expensive' ?
I know that Servoy has initial limits built in to optimise response.
And I recall that the getFoundSetCount function has the 'expensive' warning attached to it.
I guess that I really need to create a mass of dummy records and run some tests.
I cannot believe that any process run in Servoy/SQL would be >= FileMaker's unstored calculation results to get :
"rec 'x' of 'y' found from 'z' total records"
'swingman' - let me know what you decide to do as I am very interested.
Harry