>What is the trick and tips to optimise the rushmore when we doing query...SQL is faster or FOR...
To test it for yourself set up a program to run each query 1000 times, first put seconds() into a variable and at the end
? seconds() - lnseconds
see for yourself which is faster. I'm no expert but speed may depend on indexes, how you structure your query etc.
Sarah
Sarah King
pcpropertymanager.com