Re: Speeding up a dataflex application over the Web
Very interesting but not 100% sure what you are showing here ?
I think I said that ESQL fectch times were linear (as you have found) but were significantly slower than other tools/languages againsty the SAME database
One test i've never done is if you take your say 64k rows test and write a traditional while/find GT loop how does that compare with your test above ? and does the block_size setting have much of an impact ?
Also if you execute your 64k rows SQL statement directly in the SSMS I suspect it will execute and fill it's grid in a total of about 5 seconds as opposed to almost 20
If you think adventure is dangerous, try routine. It is lethal - Paulo Coelho