Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

I have to connect to a asa server 9 (64bit version) from a .net framework 2.0 client. I'm have a huge problem when filling a dataset that is about 32000 rows long. it takes a long time... checked and even if it works it loads about 5 rows per second. So for 32000 rows would take hours! the strange thing is that if I do the exact same datafill connecting to a 32bit server returning the same rows it takes a couple of seconds? how can I solve this? is there any configuration on the 64bit server that is wrong? where can I check? thx tommy

asked 22 Apr '11, 04:34

tommyp's gravatar image

tommyp
1111
accept rate: 0%

How long does it need to fetch those rows with DBISQL against both servers? Does the very irritating performance difference show up there, too? Is your Dot.Net client a 32-bit or a 64-bit client?

(23 Apr '11, 13:23) Volker Barth
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×108
×36

question asked: 22 Apr '11, 04:34

question was seen: 1,736 times

last updated: 23 Apr '11, 13:23