Steve,
I have some experience in getting at SQL Anywhere data. What I found is that if you select all columns from a table (even with just 500 rows) it is really slow. I changed my queries to only select the columns I needed and it sped up the process dramatically.
Thanks,
Rod
Rod Paddock
Editor in Chief CoDe Magazine
President Dash Point Software, Inc.
VP Red Matrix Technologies,Inc.