On 10/29/10 3:10 PM, Richard Gaskin wrote:
It'll vary, and in my own tests that seems to be the only bottleneck
with SQLit; queries that return little data are ultra speedy, but once
we get into large amounts of return data I see the hit.
Just a reminder, which you probably don't need at all, but I had this
same experience with PostGreSQL recently, but probably for different
reasons:
but FWIW...
I was using and old example SQL stack... small data returns were fast,
but a lot of data (select * from table whatever.. i.e. "everything")
from a PostGreSQL database.... adding it to a display field. It took
forever...
Then I remembered "Dont' Do That!"
When I got all the data in a variable and just posted to the field once,
it was "like 20 times faster."
skts
_______________________________________________
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