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

thaerlb
12791014
accept rate: 0%

edited 17 Jan '13, 08:36

Mark%20Culp's gravatar image

Mark Culp
23.4k9132275


thaerlb,

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

JonJon
31115
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
632202636
accept rate: 6%

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

PHoran
15
accept rate: 0%

1

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

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:

×21

question asked: 17 Jan '13, 03:35

question was seen: 1,619 times

last updated: 17 Jan '13, 23:53