almost sounds like it may be doing a table scan every time it needs to get another page of rows
you could try to do analyze the queries to see whats actually going on
almost sounds like it may be doing a table scan every time it needs to get another page of rows
you could try to do analyze the queries to see whats actually going on
Michael Salzlechner
StarZen Technologies, Inc
http.://www.starzen.com
IT Director at Balloons Everywhere
Development Blog
http://www.salzlechner.com/dev
DataFlex Package Manager (aka Nuget for DataFlex)
http://windowsdeveloper.com/dfPackage