Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

Dear sir,

i am working on powerbuilder 7 with ianywhere 8 i have problem when i put query in isql session it 's run so fast but when i load it under datawindow become so slow and my data not big.anyone can help me.

Thanks in advance.

asked 17 Jan '13, 03:35

thaerlb's gravatar image

accept rate: 0%

edited 17 Jan '13, 08:36

Mark%20Culp's gravatar image

Mark Culp


How many records your select is returning?

Below can be a reason: In isql you "see" a result when first portion of records are fetched (by default something like 500 or less). In datawindow (often) you may "see" a result when all records are fetched to datawindow.

So if your select returns some XXX number of records, i.e. 10000 or 20000 records, then you will fill that difference is big. To check - go to isql , menu Option and look there must be tab RESULT. There is limitation, how many records are fetched by default. You may select "all" records and then see - is it still fast with isql or not.

permanent link

answered 17 Jan '13, 07:59

JonJon's gravatar image

accept rate: 0%

Thanks sir it's running good i tried to delete data from system tables in database and now it's ok

(17 Jan '13, 08:07) thaerlb

if your datawindow has text or column background colors that change based on data, it can be VERY slow to render and to scroll.

permanent link

answered 17 Jan '13, 07:36

Tom%20Mangano's gravatar image

Tom Mangano
accept rate: 8%

PowerBuilder 7 with SQLAnywhere 8? Those were both released about 12 or 13 years ago... And you wonder why your queries are slow?

-Paul Horan-

permanent link

answered 17 Jan '13, 16:11

PHoran's gravatar image

accept rate: 0%


ASA 8 was a very good release. And it's not so old. So depending on queries it may be not worst in performance compare to the current one.

(17 Jan '13, 23:51) JonJon
Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 17 Jan '13, 03:35

question was seen: 4,140 times

last updated: 17 Jan '13, 23:53